OraFAQ Forum: Security » DDL auditing

Home » RDBMS Server » Security » DDL auditing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DDL auditing [message #245629]

Mon, 18 June 2007 04:31

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

Report message to a moderator

Re: DDL auditing [message #245642 is a reply to message #245629]

Mon, 18 June 2007 04:55

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

change "audit_trail" parameter to DB
restart the database
execute "audit <list of statements you want to audit for instance CREATE TABLE...>;"

For details have a look at AUDIT statement.

Regards
Michel

Report message to a moderator

Re: DDL auditing [message #248120 is a reply to message #245629]

Thu, 28 June 2007 02:09

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..

Report message to a moderator

Re: DDL auditing [message #248149 is a reply to message #248120]

Thu, 28 June 2007 03:07

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ora_sql_txt variable contains the statement that is executing.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 05:31:51 CST 2025