Obtaining Permiissions for User and Groups via VBA

[Guest]

Hi all,

I found code to obtain User Names, Groups, Users in Groups, and Groups By
User, all done in VBA. So now I can see (and export to Excel) what's what in
my application's system.mdw.

I would like to programmatically get a list of the privileges granted to all
groups and users.

This seems like it would be a very useful thing to have on hand outside the
database, in case of emergency (allong with the PINs for each user).

Does anyone know how this can be done?

rjbudz

 

[Jack MacDonald]

Check out http://www.mile50.com/access/ptrack/index.htm for a free
utility for documenting database permissions. Note that permissions
are stored in the *database file*, not in in the workgroup.

Hi all,

I found code to obtain User Names, Groups, Users in Groups, and Groups By
User, all done in VBA. So now I can see (and export to Excel) what's what in
my application's system.mdw.

I would like to programmatically get a list of the privileges granted to all
groups and users.

This seems like it would be a very useful thing to have on hand outside the
database, in case of emergency (allong with the PINs for each user).

Does anyone know how this can be done?

rjbudz

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[TC]

As well as printing them out, you could emit VBA code which, when run,
would re-establish them in a new database. Much easier than re-doing
them all by hand

For PINs, I guess you mean PIDs (Personal Identifiers). I seem to
remember that Access used the term PIN in olden days, but the current
term is PIDs.

HTH,
TC