Record Level Security?

[Guest]

Hello,

Is there a way to have record level security within a database? Or does it
not go that detailed?

Thank you!
MN

 

[Rick B]

You can. but you would have to build it.

If you are trying to allow people to only look at their own records, for
example, you'd need to include a UserID field in the records and then
compare that to the signed on user. You'd also have to take away the users
access to the tables and only allow them to pull up data through queries
(with the limitation mentioned) that were set to run with owner permission.

If that is what you are trying to do, do a search and read the previous
posts on the topic.

 

[Guest]

Very interesting, thank you for your response.

Now would this functionality allow the user to create their record, then
when they come back, they can view only their record with the limitations you
mentioned below?

 

[Rick B]

Yes.

You would build your forms based on a query. In that query you would only
select records where the userid is equal to the user signed on. Of course,
they could add records, but could only view existing records that had their
UserID in it.

To do this, you will have to implement User-Level Security, take away all
access from the tables and queries, create queries with the criteria
indicated, allow the queries to run with owner's permission, and build forms
and reports based on those queries.

Again, you can read some previous posts and get more details and maybe see
some pros and cons. Search for things like "their own records" "only their
records" "lock tables" "secure tables" "secure records" etc.

Good luck, and feel free to post back specific questions if you have them.

 

[Guest]

Thank you very, very much! I will definitely do some searches on those items
you listed, and will try this and hopefully get it to work! Thanks again for
your time!!

~MN