Syntax for Security Display Statements › DISPLAY SYSADMIN PRIVILEGES › Parameters

Parameters

ALL

Specifies all display options.

NONe

Specifies display of the privilege and the user or group to whom it was granted.

HIStory

Specifies display of the following:

• The date and time the privilege was granted to the user or group, and the ID of the user granted the privilege.
• The date and time the privilege was last updated, and the ID of the user who updated the privilege.

VERB

Specifies the verb used in the display output.

If VERB is not specified, the privilege is displayed in the form of GRANT statements.

GRAnt

Specifies display of SYSADMIN privilege in the form of GRANT statements.

REVoke

Specifies substitution of "REVOKE" for "GRANT" in the display output.