For an 11gR2 db. I know that user_role_privs will show the roles a user has...including those that are password protected and may not currently be set (through the set role command) for a particular session. And I know that session_roles will show the roles that a session currently has set. But I have yet to find a way for a DBA to see the roles that another user's session currently has set. Does anyone know how to do this? Your help is appreciated. Thanks.