Get(AccountPrivilegeSetName) ..... help please

[giles12345]

Hi,

 

I want to be able to display the AccountPrivilegeSetName for my users in the user table. I'm reading that Get(AccountPrivilegeSetName) should be able to do this for me, but the help file makes it looks as if it's going to return MY set until I change the "context" of the calculation. I'm finding little written guidance on how to do that and the test's I've tried are consistently showing MY set. 

 

Can you help

Many thanks

[Wim Decorte]

It is always going to show the priv set of the user that is logged in, not anyone else's priv set.

[comment]

the help file makes it looks as if it's going to return MY set until I change the "context" of the calculation.

 

No, it is going to return the name of the privilege set of the account that is logged in at the time the function is evaluated.

 

If you are using this in a calculation field, makes sure to set it to unstored - otherwise the function will not be re-evaluated when another user logs in, and it will keep displaying your set's name.

[giles12345]

Thanks for clarification

 

Is there ANY way for showing the privilege set of a user from the perspective of an entry in a user user table e.g.

 

user 1 | admin | etc | etc

user 2 |  staff   | etc | etc

user 3 |  temp  | etc | etc

[comment]

Is there ANY way for showing the privilege set of a user from the perspective of an entry in a user user table

 

Not that I know of. You must populate the field when you add the user and assign them to a privilege set.

 

Alternatively, if you have the Advanced version, you can get this information by producing a Database Design Report.

[giles12345]

Think I'll do that then,

 

Thanks for your help

[Steven H. Blackwell]

Please exercise extreme care is using such a table to assign or to control privileges for a user in the system.  This is an exceptionally vulnerable area.  It is a target-rich environment.

 

Steven