DDL - drop table, create table, alter table - Audit
DB: Oracle 10.2.0.4 on LinuxTables: 302
Indexes: 620
I have a requirement to Audit the following statement on the ERPROD schema for the following DDL by any users including the ERPROD:
I need Oracle to capture all these DDL audit on ERPROD user only. in our database, some users can log in as user ERPROD or themselves, i.e. log in as, Smith, Johnson, Roger,Brownstein, etc. and perform DDL.
1. Drop Table
2. Alter Table
3. Create Table
4. Drop Index
5. Alter Index
6. Create index
7. Create/Replace / Execute procedure
I tried to test the following but it did not work when I Alter or Drop tables while logged in as ERPROD. if I logged in as Roger and use the same DDL on ERPROD objects, Oracle logged these activity in dba_audit_trail table. How could I fix this?
Indexes: 620
I have a requirement to Audit the following statement on the ERPROD schema for the following DDL by any users including the ERPROD:
I need Oracle to capture all these DDL audit on ERPROD user only. in our database, some users can log in as user ERPROD or themselves, i.e. log in as, Smith, Johnson, Roger,Brownstein, etc. and perform DDL.
1. Drop Table
2. Alter Table
3. Create Table
4. Drop Index
5. Alter Index
6. Create index
7. Create/Replace / Execute procedure
I tried to test the following but it did not work when I Alter or Drop tables while logged in as ERPROD. if I logged in as Roger and use the same DDL on ERPROD objects, Oracle logged these activity in dba_audit_trail table. How could I fix this?
1