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