GRANT Format 2 (Change auditor's password)

Nonstop Database, HiRDB Version 9 SQL Reference

Function

GRANT format 2 changes the auditor's password.

Privileges

Users with the audit privilege: These users can change the password owned by an auditor.

Format

 
 GRANT AUDIT IDENTIFIED BY password

Operands

Specifies a new password for the auditor.

If the password is to be case-sensitive, specify it by enclosing it in double quotation marks (").

Examples

Change the auditor's password to a0h7Fc3:

GRANT AUDIT IDENTIFIED BY "a0h7Fc3"