Re: Why won't roles work

From: Heiko Herms <Heiko.Herms_at_BITOEK.UNI-BAYREUTH.DE>
Date: Tue, 6 Feb 1996 08:54:41 EST
Message-Id: <9602060816.AA25793@alice.jcc.com>

Have a look with SQLPLUS to the following system tables:

Currently logged in user

---

SESSION_ROLES : : all roles
USER_ROLE_PRIVS : privileges on roles above ROLE_SYS_PRIVS : all system rights

All Users/All Roles

---

SYS.ROLE_TAB_PRIVS (only for DBA)
ROLE_TAB_PRIVS : privileges on database objects per role

Hope this helps. Received on Tue Feb 06 1996 - 03:16:05 CST