| How To monitor triggers behavior of schemas [message #632500] |
Mon, 02 February 2015 00:21  |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear All,
Every day, some of the triggers are getting DISABLE.
May be some of the developer executing script explicitly to disable the trigger of schema's. But, no one aware of it.
Since, the owner is having DBA rights. Please suggest, how can we find out the cause of it?
I have enabled the parameter audit as DB. But it will audit only sys users behavior. This problem is happening for non-sys user.
Waiting for your kind response on the same...
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
| Re: How To monitor triggers behavior of schemas [message #632558 is a reply to message #632502] |
Tue, 03 February 2015 03:15  |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear Michel,
Main concern is to find out who is executing sql statements to change the status of triggers from Enable to Disable.
After changing the parameter values of audit_trail from none to db. All the statements are getting captured in dba_common_audit_trail view.
Through which, I can get the statements along with user's details.
My problem is resolved, now.
Thanks,
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
