GRANT Format 2 (Change auditor's password)
Function
GRANT format 2 changes the auditor's password.
Privileges
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"