Display Privilege

View a list of privileges, calculations, or filters held by users or groups.

Syntax

Examples

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.

Descriptions

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.

Output Columns

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