OraFAQ Forum: Security » how to know who disable a trigger

Home » RDBMS Server » Security » how to know who disable a trigger

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

how to know who disable a trigger [message #235517]

Mon, 07 May 2007 00:53

win3vin
Messages: 35
Registered: April 2007
Location: Malaysia

Member

Hi

I have a few triggers that was disable by a user. But all the user said there are not doing it. Is there any way to trace which user disable the trigger?

thanks.

Report message to a moderator

Re: how to know who disable a trigger [message #235521 is a reply to message #235517]

Mon, 07 May 2007 00:58

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

Senior Member
Account Moderator

Yes:
- set audit_trail parameter to db
- execute "audit alter trigger"

Regards
Michel

Report message to a moderator

Re: how to know who disable a trigger [message #235531 is a reply to message #235517]

Mon, 07 May 2007 01:28

win3vin
Messages: 35
Registered: April 2007
Location: Malaysia

Member

Thanks Michel.

are we able to capture those trigger that we previously disabled?

btw, after we execute it, where to find the the audit? thanks

Report message to a moderator

Re: how to know who disable a trigger [message #235537 is a reply to message #235531]

Mon, 07 May 2007 01:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

are we able to capture those trigger that we previously disabled?
No.

btw, after we execute it, where to find the the audit? thanks

dba_audit_trail;

Report message to a moderator