Security Problem

[BCarruth]

Trying to find information on how to set up security on a database so that users can only access the data they are responsible for in the tables. I know the user level security prevents acessing forms, reports, etc. but I have people that I want them to only see their records when they log onto the database.

Thanks for the knowledge
Bob

 

[scking]

Bob,

User level security can be tuned however you want. In your case you could create a parameterized query based on the CurrentUser function then give read/write permissions for the query only to users. You may even need to run it with Owners Permissions. This is just one method. The information you provided does not give enough information to be able to recommend an exact solution. What you need to know is that if there is any means of deriving what records are associated with the current user you can solve the problem. This could mean a field in the tables for owner or a lookup table that associates the current user to some fields in the data tables. You need to be imaginative to get these to work effectively.

Steve King