Auditing when user set the role only
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Aug 2009 21:31:32 +0530
Hello DBA's
Good Morning!!
Hope Everyone is fine and doing great.
I have a requirement where in I need to audit every statement issued by a
user who sets(enable) the role. I have granted the role to a particular set
of users. If the user has not set the role then it should not audit. I
thought of doing it by a trigger. But how do we come to know that the user
has enabled a role or not. Is it also possible to do it without using the
trigger??. Please advise, how to do this.
Thanks
Nilesh
Other related posts:
