How to get the access rights for a selected user??

[KirkR]

Is there anyway to return the rights that a selected user has? Not the current user, but a selected user from a list.

I have my user setup layout, where I add users and accounts, but I would like to list what privilege they are assigned.

I know I can set a text entry into a field when I create the account, but was hoping there would be a way to put the Get ( PrivilegeSetName) into the field, which should be more foolproof.

Using a calc field returns nothing - the new record trigger occurs prior to the account being established - I think that is the problem with that approach. (the whole concept of how to trigger GET functions is perplexing - why are functions allowed in places where they don't work?)

Setting the field from the Get(PrivilegeSetName) writes the privilege for the current user, which, by function of being able to maintain user accounts, is [Full Access].

Suggestions? Or am I resigned to pushing text into the field?

[Wim Decorte]

You can't do what you want, because it would be an obvious security risk. If I could get a list of all users and their priv sets I would know which ones to attack to get the highest possible level.

If you need account management, use External Authentication or use something like "Security Administrator" from www.nmci.com

[Steven H. Blackwell]

You can grant a subordinate level user the ability to create and manage Accounts. Take a look at the Account management script steps.

Ot do as Wim suggests.

Steven