Re: Help: Roles in session

From: <chris_at_sky_at_my-dejanews.com>
Date: Tue, 09 Feb 1999 17:34:23 GMT
Message-ID: <79priu$h76$1@nnrp1.dejanews.com>

Not really.

This shows all the roles a user (or role) has been granted. What I wanted to find was which ones a session has currently got enabled.

You can check this for your own session via 'SELECT * FROM SESSION_ROLES', but what I wanted was a 'DBA' equivalent which allowed me to determine what role(s) a session other than my own has enabled.

This information would then let me find out which front-end application they were currently connected to the database by (v$session.program does not give me enough info for this).

> > >
>
> Select * from dba_role_privs;
> is this what you want ?
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 09 1999 - 11:34:23 CST