In Oracle, I can view the currently set roles for my current session using the query SELECT * FROM SESSION_ROLES.

Is there any way that I can see this information for another session?

1 Answer 1


SESSION_ROLES view shows list of roles assigned after you makes session in instance as those roles granted to your connected users. you can view other users granted roles using below:

select   * from   dba_role_privs;

If you want to know list of roles of particular user, use below query:

select   * from   dba_role_privs where grantee='USER_NAME'; 

Please note that you must have DBA privilege to view above. and you can't see list of roles using currently connected others session. you can only see what role the can be use after getting connected.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.