You can give them the necessary permissions on the table (e.g., Update,
Delete, Insert)
--------------------
| Content-Class: urn:content-classes:message
| From: "kathy" <
[email protected]>
| Sender: "kathy" <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: restrict report info
| Date: Wed, 14 Jan 2004 11:36:46 -0800
| Lines: 96
| 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
| thread-index: AcPa1b8vFsKax+LhTD+83QaR2CHUEQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.security:7496
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.security
|
| I have never set up User Level Security, can you please
| tell me if the users will still be able to add to the table
| doing it this way? These users are the ones who add &
| update the table.
|
| Thank you!
| Kathy
| >-----Original Message-----
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "kathy" <
[email protected]>
| >| Sender: "kathy" <
[email protected]>
| >| Subject: restrict report info
| >| Date: Tue, 13 Jan 2004 12:38:01 -0800
| >| Lines: 10
| >| 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
| >| Thread-Index: AcPaFSMGPQMbEo0USRukkdxr/EthPg==
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Newsgroups: microsoft.public.access.security
| >| Path: cpmsftngxa07.phx.gbl
| >| Xref: cpmsftngxa07.phx.gbl
| microsoft.public.access.security:7461
| >| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| >| X-Tomcat-NG: microsoft.public.access.security
| >|
| >| Is there a way to set reports that only allow users to
| run
| >| the reports on their own user id even though they have
| full
| >| access to the table info? Manager here does not want
| users
| >| running production numbers on co-workers to compare
| work.
| >| Looking for something to the effect of if you are logged
| in
| >| under your user id then can only access your id's
| >| information in the report.
| >|
| >| Thanks!
| >| Kathy
| >|
| >
| >Hi Kathy,
| >
| >You want to use User Level Security in Microsoft Access.
| Make sure you
| >have the following:
| >- the user's account in question only has permission to
| read data on the
| >QUERY that has his UserID as the criteria. DONOT give the
| user account
| >permissions on the Table.
| >
| >- for the QUERY property "Run Permissions" set it to
| Owners
| >
| >So what you end up with is a query that has a criteria of
| the UserID, and
| >it's Run Permissions set to Owners, and the user's account
| only has Read
| >Data permissions on that Query
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
| >"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."
| >
| >
| >.
| >
|
