5 Replies Latest reply on Jun 11, 2014 4:36 PM by BPeaslandDBA

    Checking permissions of a users session


      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