Re: Help: Roles in session

From: <yewpc_at_my-dejanews.com>
Date: Tue, 09 Feb 1999 08:41:32 GMT
Message-ID: <79osbr$me6$1@nnrp1.dejanews.com>

In article <Dh2MRFAz51v2Ewr4_at_cjmcjm.demon.co.uk>,   Chris May <chris_at_cjmcjm.demon.co.uk> wrote:
> In article <36c22eee.13649727_at_192.86.155.100>, Thomas Kyte
> <tkyte_at_us.oracle.com> writes
> >A copy of this was sent to jdanton1_at_yahoo.com
> >(if that email address didn't require changing)
> >On Mon, 08 Feb 1999 16:43:59 GMT, you wrote:
> >

Select * from dba_role_privs;
is this what you want ?

> >>To all:
> >>
> >>I can't seem to find a way in the V$ views to tell which user roles are
> >>enabled for particular session. Does anyone know a way to identify this
> >>information?
> >>
> >>Thanks,
> >>
> >>Joey D'Antoni
> >>
> >>-----------== Posted via Deja News, The Discussion Network ==----------
> >>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
> >SQL> select * from session_roles;
> >
> >ROLE
> >------------------------------
> >PKT_TEST_USER
> >PLUSTRACE
> >SURVEY_USER
> >CONNECT
> >DBA
> >SELECT_CATALOG_ROLE
> >HS_ADMIN_ROLE
> >EXECUTE_CATALOG_ROLE
> >DELETE_CATALOG_ROLE
> >EXP_FULL_DATABASE
> >IMP_FULL_DATABASE
> >
> >11 rows selected.
> >
> >Thomas Kyte
> >tkyte_at_us.oracle.com
> >Oracle Service Industries
> >Reston, VA USA
> >
> >--
> >http://govt.us.oracle.com/ -- downloadable utilities
> >
> >----------------------------------------------------------------------------
> >Opinions are mine and do not necessarily reflect those of Oracle Corporation
> >
> >Anti-Anti Spam Msg: if you want an answer emailed to you,
> >you have to make it easy to get email to you. Any bounced
> >email will be treated the same way i treat SPAM-- I delete it.

>

> On a similar vein -

>

> does anyone know how to tell which roles are currently enabled for a session
> other than your own?

>

> --
> Chris May

>

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