9 Replies Latest reply on Jun 14, 2013 2:45 AM by rp0428

    How to know which privileges/roles are used by a session


      Is there any way we can know which privileges / roles are used by a session.
      I want to know this so that only those privileges can be granted to separate user by which the said operation will ran later on.

      Suppose, I want to create a new user by which the new batch job will be ran.
      First time I want to run that batch job using sys/system or more privileged user and know the list of privileges which got used during execution of the batch job. Later on want to grant only the list those privileges/ role to the newly created user so that the user has all and only those privileges /roles required.