View a list of privileges, calculations, or filters held by users or groups.
Syntax
You can display security permissions in the following ways using display privilege.
Keyword | Description |
---|---|
user... | Display security permissions for all users, or for a specified user. |
group... | Display security permissions for all groups, or for a specified group. |
Output Columns
The values returned for the type field are numeric, and translate as follows:
Column | Description |
---|---|
1 | |
2 | |
3 | Execute calculation |
4 | Filter |
Example
display privilege user Fiona;
Displays the privileges user Fiona has on each database object, including any calculations or filters granted to Fiona.
display privilege group;
Displays privileges held by all groups on the system to all applications and databases on the system.