View a list of privileges, calculations, or filters held by users or groups.
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.
You can display security permissions in the following ways using display privilege.
| Key Phrase | Explanation |
|---|---|
| user... | Display security permissions for all users, or for a specified user. |
| group... | Display security permissions for all groups, or for a specified group. |
The values returned for the type field are numeric, and translate as follows:
| Constant | Value |
| 1 | System-level privilege |
| 2 | System-level role |
| 3 | Execute calculation |
| 4 | Filter |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |