Obtaining Permiissions for User and Groups via VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
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
 
Back
Top