Home » RDBMS Server » Security » how to know who disable a trigger
how to know who disable a trigger [message #235517] Mon, 07 May 2007 00:53 Go to next message
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.
Re: how to know who disable a trigger [message #235521 is a reply to message #235517] Mon, 07 May 2007 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes:
- set audit_trail parameter to db
- execute "audit alter trigger"

Regards
Michel
Re: how to know who disable a trigger [message #235531 is a reply to message #235517] Mon, 07 May 2007 01:28 Go to previous messageGo to next message
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

Re: how to know who disable a trigger [message #235537 is a reply to message #235531] Mon, 07 May 2007 01:43 Go to previous messageGo to next message
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;

Re: how to know who disable a trigger [message #235574 is a reply to message #235521] Mon, 07 May 2007 04:49 Go to previous messageGo to next message
akshayag_krishna
Messages: 2
Registered: January 2007
Location: xxx
Junior Member

Hi,
Sorry i didnt understand how 2 do plz explain me clearly
Re: how to know who disable a trigger [message #235579 is a reply to message #235574] Mon, 07 May 2007 05:06 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just follow what has been said.

Regards
Michel
Previous Topic: to GRANT Privilege
Next Topic: conn as SYSDBA
Goto Forum:
  


Current Time: Thu Mar 28 09:14:54 CDT 2024