GRANT Format 2 (Change auditor's password)

Scalable Database Server, HiRDB Version 8 SQL Reference

Function

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"