Database Administration (MOSC)

MOSC Banner

create and assign audit policy to capture, create, alter, drop, enable or disable job

I have created some policies as below and assigned to two users.

Example:

CREATE AUDIT POLICY USER_PROCEDURE_AUDIT_TEST ACTIONS CREATE PROCEDURE,DROP PROCEDURE;

CREATE AUDIT POLICY USER_TABLE_AUDIT_TEST ACTIONS CREATE TABLE,TRUNCATE TABLE,ALTER TABLE, DROP TABLE;


Question: same as above, I would like to create policy to audit Create, Alter, Drop, Enable and disable job, as below but it does not work, any thoughts? I need to assigned to only two users only

CREATE AUDIT POLICY USER_JOB_AUDIT ACTIONS CREATE JOB , ALTER JOB, DROP JOB, ENABLE JOB, DISABLE JOB;

Getting error, ORA-46356 MISSING OR INVALID ACTION AUDIT OPTION

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