Rem drv: Rem Rem $Header: audit_post_creation.sql 03-jul-2005.19:40:40 gsbhatia Exp $ Rem Rem audit_post_creation.sql Rem Rem Copyright (c) 2005, Oracle. All rights reserved. Rem Rem NAME Rem audit_post_creation.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem gsbhatia 07/03/05 - New repmgr header impl Rem shianand 03/02/05 - Rem shianand 02/10/05 - Rem shianand 02/03/05 - shianand_audit Rem shianand 01/30/05 - Created Rem --TABLE MGMT_AUDIT_MASTER insert into MGMT_AUDIT_MASTER (audit_level) values (2); --TABLE MGMT_AUDIT_DESTINATION insert into MGMT_AUDIT_DESTINATION (audit_mode, audit_destination) values (0, null); --TABLE MGMT_OPERATIONS_MASTER insert into MGMT_OPERATIONS_MASTER values (1, 'change_password', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (2, 'create_user', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (3, 'delete_user', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (4, 'logon', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (5, 'logoff', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (6, 'grant_role', 1, 'user_name', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (7, 'grant_target_priv', 1, 'user_name', 'target_name','target_type', 'target_owner', null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (8, 'revoke_role', 1, 'user_name', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (9, 'revoke_target_priv', 1, 'user_name', 'target_name','target_type', 'target_owner', null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (10, 'submit_job', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (11, 'edit_job', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (12, 'delete_job', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (13, 'change_pref_cred', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (14, 'modify_user', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (15, 'grant_system_priv', 1, 'user_name', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (16, 'grant_job_priv', 1, 'user_name', 'job_name', 'job_type', 'job_owner', null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (17, 'revoke_system_priv', 1, 'user_name', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (18, 'revoke_job_priv', 1, 'user_name', 'job_name', 'job_type', 'job_owner', null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (19, 'remote_op', 1, 'step_id', 'step_status', 'args', 'input', 'remote_command', 'target_name', 'target_type', 'user_name', null, null, null, null, null, null, null, 'output'); insert into MGMT_OPERATIONS_MASTER values (20, 'get_file', 1, 'step_id', 'step_status', 'dest_file', 'dest_type', 'source_file', 'target_name', 'target_type', 'user_name', null, null, null, null, null, null, null, 'output'); insert into MGMT_OPERATIONS_MASTER values (21, 'put_file', 1, 'step_id', 'step_status', 'dest_file', 'source_file', 'source_type', 'target_name', 'target_type', 'user_name', null, null, null, null, null, null, null, 'output'); insert into MGMT_OPERATIONS_MASTER values (22, 'file_transfer', 1, 'step_id', 'step_status', 'dest_file', 'dest_target_name', 'dest_target_type', 'dest_args', 'dest_command', 'dest_user_name', 'source_file', 'source_target_name', 'source_target_type', 'source_args', 'source_commands', 'source_user_name', null, 'output'); insert into MGMT_OPERATIONS_MASTER values (23, 'create_role', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (24, 'delete_role', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); insert into MGMT_OPERATIONS_MASTER values (25, 'modify_role', 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);