Home » RDBMS Server » Security » User-specific trigger auditing
User-specific trigger auditing [message #173614] Tue, 23 May 2006 08:09 Go to next message
adeli
Messages: 14
Registered: May 2006
Junior Member
Hi all,

I want to create an auditing system in Oracle. Specifically, I have 2 types of users (let's name them group A and group B). I want to log activity of users in group A using triggers (inserts, delete, updates) but not for users in group B. I can create triggers and inside the trigger get the username and then execute the body of the trigger depending on the user, but this still means that the trigger will fire even for users in group B (even though nothing will be logged).

Is there any way to prevent the triggering for users in group B?

Thank you,
Anthony

ps: I am using Oracle 9i but can switch to 10g if this is necessary for the auditing part.
Re: User-specific trigger auditing [message #174352 is a reply to message #173614] Sun, 28 May 2006 07:28 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
In the trigger check the username and take approprite action.
Previous Topic: REVOKE [privilege] ON [owner].[object] FROM PUBLIC
Next Topic: Not able to check the SQL statements used by user- need help
Goto Forum:
  


Current Time: Fri Mar 29 09:19:55 CDT 2024