5 Replies Latest reply: Jun 11, 2014 11:36 AM by BPeaslandDBA RSS

    Checking permissions of a users session

    1055717

      I have an issue with a 3rd party vendor application

       

      The application is very poor (It requires DBA access)

       

      I believe the application does the following when a user logs in

       

      user1 create a session

      This is turn fires a trigger/procedure (which I cannot see the code for as it is encrypted)

      The trigger grants user1 a bunch of roles, then executes user1's sql statement and the revokes the roles (even though user1's statement is still running)

       

      Sometimes user1's sql statement can take a couple of hours to run

       

      During this time, is it possible to check what roles were granted to user1's session?

      I'm thinking one of the x$tables will have the answer

       

      This is a Dev env and there is nothing in the dba_audit_trail

      G.