How to Audit Grant and Revoke Commands

Ankush Chawla-Oracle
Ankush Chawla-Oracle Orion GCS Customer Posts: 6 Green Ribbon

hi team,

Oracle Database 11.2.0.4

What is the commands I can audit Grant and Revoke Commands in the database.

There is no option I am finding it out .

Audit grant, revoke; -- does not work

Thanks for your help.


regards

Answers

  • Santhosh Tirunahari-Oracle
    Santhosh Tirunahari-Oracle Orion GCS Customer Posts: 2

    USER_AUDIT_STATEMENT displays audit trail records for the GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user.

    Thanks,

    Santhosh