Re: Help: Roles in session

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 08 Feb 1999 18:37:45 GMT
Message-ID: <36c22eee.13649727@192.86.155.100>

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. Received on Mon Feb 08 1999 - 12:37:45 CST