This content has been marked as final. Show 3 replies
861100 wrote:It is if you had the appropriate auditing options set.
Hi all ,
we have an issue here can we know the privs of users ,
ex: username called test can i know in 2:00 am he have privs let us say select and in 3:00 am
some one give him delete in 5 pm the privs was revoke from sys users and any users
is this possible???
Turn audit on if it isn't.
But if sys is granting, I think you must allow audit_sys_operations = TRUE in your spfile.
SQL> audit grant any object privilege by access; SQL> audit grant any privilege by access; SQL> audit grant any role by access;