How to Audit Grant and Revoke Commands

Ankush Chawla-Oracle
Ankush Chawla-Oracle Posts: 2 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 Posts: 2 Green Ribbon

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

    Thanks,

    Santhosh