@UserPrivileges (Formula Language)
Returns a text list of the current user's privileges. This function returns only the position of the privilege in the privilege list, not the name of the privilege.
Note: This @function is obsolete in Release 3. Use @UserRoles instead.
Syntax
@UserPrivileges
Return value
privileges
Text or text list.
Usage
This function does not work in scheduled agent formulas.
You cannot use this function in Web applications.
Examples
- A database has five privileges. User Mary Tsen has been assigned
Privileges 2 and 3. This example returns the text list 2:3 (which
displays as 2;3 if the multi-value separator for the field containing
the formula is semicolon).
@UserPrivileges
- This form formula causes the Marketing Report form to be used
if the current user has been assigned the first privilege in the list
(regardless of what it is called); otherwise, the Main Topic form
is used.
@If(@UserPrivileges = "1"; "Marketing Report"; "Main Topic")