Re: where is role data stored?

In article <DJH6pw.HMK_at_ncrcae.ColumbiaSC.ATTGIS.COM>,

   Kranti Atluri <Kranti.Atluri_at_ColumbiaSC.NCR.COM> wrote:
>Try logging in as the role you created and query up session_privs, that
 should
>give you the priveleges which are currently available to the user.
>
>
>
>AT&T Global Information Solutions
>Kranti Atluri
>Kranti.Atluri_at_ColumbiaSC.NCR.COM
>(803) 939-1234
>

Log in as a user with DBA privilege.. System ??

Submit query ..

Select * from DBA_ROLES
/

select * from DBA_ROLE_PRIVS
/

select * from DBA_SYS_PRIVS
/

You can also join the three queries into one SQL.

Ashu

                                     TechnoSolutions Corporation. Received on Wed Dec 13 1995 - 00:00:00 CET