Acme Packet (MOSC)

MOSC Banner

Stmt_audit_option_map entries

edited Oct 12, 2015 11:24AM in Acme Packet (MOSC) 1 commentAnswered

In the table stmt_audit_option_map, there are entries like this:

OPTION#  NAME

24  SYNONYM

25 PUBLIC SYNONYM

80 CREATE SYNONYM

92 DROP ANY SYNONYM

895 CREATE PUBLIC SYNONYM

If I did the following statement:

AUDIT CREATE SYNONYM BY ACCESS;  -- Then I assume that anybody that ran the CREATE SYNONYM statement would be audited.

But, what would happen if I did:

AUDIT SYNONYM BY ACCESS;

Does this mean that anybody that accessed any synonym would be audited??????

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center