Row Level Security

  • Thread starter Thread starter Dave I
  • Start date Start date
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
 
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.
 
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
 
Back
Top