Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Roles in session
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
Received on Mon Feb 08 1999 - 16:00:19 CST