Found intresting audit parameter in 11Gr2, enable_ddl_logging will allow the tracking of all ddl's in the alert log using the following:
Enable it by using the below command.
ALTER SYSTEM SET enable_ddl_logging=TRUE
All the DDL commands executed against the database will be recorded in the alert<SID>.log
More details of the DDL of the command executed can be found in the XML file in the alert directory
Enable it by using the below command.
ALTER SYSTEM SET enable_ddl_logging=TRUE
All the DDL commands executed against the database will be recorded in the alert<SID>.log
More details of the DDL of the command executed can be found in the XML file in the alert directory
No comments:
Post a Comment