Record Level Security

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

This has been an age old question for my group. Please
help. I have a table of employees, each of which are
assigned to various departments. I also have users that
are only privied to their repective departments within
that table.

Question: How do I set up record level security so that
a user can only see his/her departments (records)?
 
Hi Dave,

You would need to use Queries.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "dave" <[email protected]>
| Sender: "dave" <[email protected]>
| Subject: Record Level Security
| Date: Wed, 4 Aug 2004 14:21:53 -0700
| Lines: 9
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcR6aRBf2OBoZIxCTjuGpHLFuv81xw==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12590
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.security
|
| This has been an age old question for my group. Please
| help. I have a table of employees, each of which are
| assigned to various departments. I also have users that
| are only privied to their repective departments within
| that table.
|
| Question: How do I set up record level security so that
| a user can only see his/her departments (records)?
|
|
 
You will need to add a field to your table that you can use in the
criteria of a query to display just the appropriate records. Secondly,
once you implement User-Level security, you can use the CurrentUser()
as the query criteria.

Other enhancements: Read With Owners Permission queries allow you to
deny permission for users to open the base tables, but instead to work
only with the queries that you predefine. The queries would use the
CurrentUser() function so that only the appropriate records are
displayed. RWOP queries are explained in the Security FAQ that you can
find on the website in my signature.

There is no built-in "group-level equivalent" to the CurrentUser()
function, but you could find one in the Security FAQ.



This has been an age old question for my group. Please
help. I have a table of employees, each of which are
assigned to various departments. I also have users that
are only privied to their repective departments within
that table.

Question: How do I set up record level security so that
a user can only see his/her departments (records)?
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