3 Replies Latest reply: Jan 10, 2013 4:09 PM by 864103 RSS

    username privs

    864103
      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???
        • 1. Re: username privs
          EdStevens
          861100 wrote:
          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???
          It is if you had the appropriate auditing options set.
          • 2. Re: username privs
            GReboute
            Hi,
            Turn audit on if it isn't.
            Then
            SQL> audit grant any object privilege by access;
            SQL> audit grant any privilege by access;
            SQL> audit grant any role by access;
            But if sys is granting, I think you must allow audit_sys_operations = TRUE in your spfile.
            • 3. Re: username privs
              864103
              thanks .