Row Level Security

D

Dave I

This is a question that's been roubling me for some time
now. I have a table with employees in it with their
associated business areas. How do I restrict specific
users from seeing certain rows (business areas) that they
are not privied to?

Any advice would be appreciated.

Dave
HR
 
L

Lynn Trapp

You will need to add a field to store the User's name. Then you will need to
implement user level security as explained in the Secuity FAQ (there is a
link to it on the security page of my website). You can then use the
CurrentUser function to limit what your users see.
 
J

Jack MacDonald

In addition to Lynn's comments, you can implement
ReadWithOwnersPermission (RWOP) queries so that the users are denied
access to the raw tables, but can use the data that you choose via the
queries. RWOP queries are explained in the Microsoft Security FAQ.

This is a question that's been roubling me for some time
now. I have a table with employees in it with their
associated business areas. How do I restrict specific
users from seeing certain rows (business areas) that they
are not privied to?

Any advice would be appreciated.

Dave
HR
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 Missing User Level Securitty - ARRRGGGGHHHH What were they thinking? 10
Record Level Security 2
Level resource allocation error 1
Setting Up Switchboard Level Security 0
User level security in Access 2007 1
First time setting up security 1
user level security 1
Problem adding group to user-level security 3

Top