Viewing assigned roles.

[litton1]

Is it possible for a user to view roles that are assigned to him? Sorry if this a simple question I am very new to Oracle.

I have created three roles SU(super) EU(extended) GU(general user). What I would like to be able to do is when logged in as a general user I would like to be able to view what grants are in my roles. I.e. does my role allow me to use view all_details (this is view) as I can then catch this in the c# app and decide which view to use, hope this makes sense. Thx in advance.

Age is a consequence of experience

 

[Dagon]

select * from session_roles

 

[litton1]

Hi thanks for the reply. Thats great thx!

Age is a consequence of experience