Display Privilege

The MaxL display privilege statement helps you view Essbase assigned privileges, calculations, and filters held by users and groups.

Syntax

Description of the illustration disppriv.gif

• USER-NAME

• GROUP-NAME

You can display security permissions in the following ways using display privilege.

Keywords

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:

Table 3-2 Output Columns

Column	Description
1	System-Level System Privileges
2	System-Level System Roles
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.