Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 25th, 2005, 05:31 AM
Authorized User
 
Join Date: Mar 2005
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Outputting table permissions

Hello! I need to know what permissions are set for each table in my database . I know I could use Tools/Security/Permissions for that, but there are ~200 users and 100 tables in my database. So, i need maybe some VBA code for retrieving a compact report, which allow me to find easily what are the differences between 2 users permissions for each table. Thank you!
 
Old May 25th, 2005, 06:39 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   Well, you can do this like this:

1. Go to Tools>Analyze>Documenter

2. Select the tables you want from the tables tab, or hit Select All.

3. Click Options in the lower right of the form

4. Deselect Properties and Relationships in Include For Table

5. Select Nothing for Include for Fields, and Nothing in Include for Indexes

6. Click Ok, and Ok.

This will generate a report by Table of who has what permissions based on User and Group.

I am not sure if there is a way to do ths by User, for example.

HTH


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Outputting values of a selection effection XSLT 7 September 4th, 2008 12:02 PM
Outputting Array manih C++ Programming 2 June 14th, 2006 08:24 PM
Alter Table Permissions Colonel Angus SQL Server 2000 2 September 21st, 2005 07:29 AM
Outputting an end of line y_simonson XSLT 1 February 5th, 2004 05:57 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.