|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Obtaining Permiissions for User and Groups via VBAHi 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. On Mon, 18 Jul 2005 13:57:01 -0700, "rj_budz" <rjb***@discussions.microsoft.com> wrote: Show quoteHide quote >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 jackmacMACdon***@telusTELUS.net 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 
Other interesting topics
|
|||||||||||||||||||||||
