| User-specific trigger auditing [message #173614] |
Tue, 23 May 2006 08:09  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
