Syntax for Security Display Statements › DISPLAY USER › Parameters

Parameters

ALL

Specifies all display options.

NONe

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

DETails

Specifies display of the following information about the user:

• The status of the user identifier.
• The user's name.
• Whether a password has been assigned to the user.
• The user profile, if any, associated with the user.
• The description, if any, of the user.

HIStory

Specifies display of the following:

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

GROups

Specifies display of all groups of which the user is a member.

all PRIvileges

Specifies display of all privileges held by the user.

ACCess MODule privileges

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

ACTivity privileges

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

AREa privileges

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

CATegory privileges

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

DB privileges

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

DBADMin privileges

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

DBTable privileges

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

DCADMin privileges

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

DMCl privileges

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

GROup PRIvileges

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

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

NONSQL SCHema privileges

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

SCHema privileges

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

SYSADMin privileges

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

SYStem privileges

Specifies display of privileges on systems (including SIGNON), if any are held by the user.

SYStem PROfile privileges

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

TABle privileges

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

USEr privileges

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

USEr PROfile privileges

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