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!

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