Syntax for Security Display Statements › DISPLAY GROUP › Parameters

Parameters

ALL

Specifies all display options.

NONe

Specifies display of the group identifier and its status (active or logically deleted).

DETails

Specifies display of the status of the group and a description of the group, if one is included in the definition.

HIStory

Specifies display of the following:

• The date and time the group definition was created, and the ID of the user who created the definition.
• The date and time the group definition was last updated, and the ID of the user who updated the definition.

USErs

Specifies display of all users who are members of the group.

all PRIvileges

Specifies display of all privileges held by the group.

ACCess MODule privileges

Specifies display of privileges on access modules, if any are held by the group.

ACTivity privileges

Specifies display of privileges on activities, if any are held by the group.

AREa privileges

Specifies display of privileges on areas, if any are held by the group.

CATegory privileges

Specifies display of privileges on categories, if any are held by the group.

DB privileges

Specifies display of privileges on databases, if any are held by the group.

DBADMin privileges

Specifies display of DBADMIN privilege, if it is held by the group.

DBTable privileges

Specifies display of privileges on database name tables, if any are held by the group.

DCADMin privileges

Specifies display of DCADMIN privilege, if it is held by the group.

DMCl privileges

Specifies display of privileges on DMCLs, if any are held by the group.

GROup privileges

Specifies display of privileges on groups, if any are held by the group.

NONSQL SCHema privileges

Specifies display of privileges on non-SQL-defined schemas, if any are held by the group.

SCHema privileges

Specifies display of privileges on SQL-defined schemas, if any are held by the group.

SYSADMin privileges

Specifies display of SYSADMIN privilege, if it is held by the group.

SYStem privileges

Specifies display of privileges on systems, if any are held by the group.

SYStem PROfile privileges

Specifies display of privileges on system profiles, if any are held by the group.

TABle privileges

Specifies display of privileges on tables, if any are held by the group.

USEr PRIvileges

Specifies display of privileges on users, if any are held by the group.

Note that at least the first three characters of the keyword PRIVILEGES must be specified to display users on which the group holds privileges. This removes any potential ambiguity with specification of the preceding USERS display option.

USEr PROfile privileges

Specifies display of privileges on user profiles, if any are held by the group.