| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Roles in session
Chris May 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:
> >
> >>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
Closest I know of is looking at DBA_ROLE_PRIVS...but this won't pick up any changes that someone may have issued with set role etc ...
Cheers
--
 |
 |