GRANT Format 2 (Change auditor's password)

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"