Home » RDBMS Server » Security » DDL auditing
DDL auditing [message #245629] Mon, 18 June 2007 04:31 Go to next message
khawish
Messages: 12
Registered: May 2007
Junior Member
hi ,


can anyone tell me how to implement ddl auditing for the database.. the procedure for it...or any script.


thanks

regards
Re: DDL auditing [message #245642 is a reply to message #245629] Mon, 18 June 2007 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
  1. change "audit_trail" parameter to DB
  2. restart the database
  3. execute "audit <list of statements you want to audit for instance CREATE TABLE...>;"

For details have a look at AUDIT statement.

Regards
Michel

Re: DDL auditing [message #248120 is a reply to message #245629] Thu, 28 June 2007 02:09 Go to previous messageGo to next message
khawish
Messages: 12
Registered: May 2007
Junior Member
hi,

i have implemented a ddl trigger to record the ddl actions performed , but it just shows e.g a table is being altered..what i want is , to show which column/columns of the table is being altered and so on.. in detail...

and what about its effect on database..pros and cons of using such type of auditing...

thnx in advance..
Re: DDL auditing [message #248149 is a reply to message #248120] Thu, 28 June 2007 03:07 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora_sql_txt variable contains the statement that is executing.

Regards
Michel
Previous Topic: Read-only schema with acces to package code
Next Topic: Create user using another user's password
Goto Forum:
  


Current Time: Thu Mar 28 15:42:04 CDT 2024