RE: Role Privileges

At 02:51 PM 1/15/02 -0800, you wrote:
>Wrong... DBA_TAB_PRIVS will show you ANYONE who granted privs to the
>grantee you specify...

I'm sure it's supposed to, but it does not. I need another way.

>-----Original Message-----
>Sent: Tuesday, January 15, 2002 5:29 PM
>To: Multiple recipients of list ORACLE-L
>
>
>At 12:25 PM 1/15/02 -0800, you wrote:
> >dba_tab_privs will show you privileges granted to anyone, including
> >roles
>
>Yes, it will show privileges granted TO anyone, but only those privileges
>granted BY me (or whoever I am logged in as). I need to know how to see
>the privileges granted even when I don't know who they were granted by.
>
>
> >select table_name, privilege from dba_tab_privs where grantee='<role>';
> >
> >
> >--- Regina Harter <rharter_at_emc-inc.com> wrote:
> > > Okay, I knew this was going to happen one day, but I kept hoping as
> > > we
> > > upgraded the problem would be corrected eventually.
> > >
> > > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > > by the
> > > logged on user. It wasn't such a problem before because I created
> > > most of
> > > the roles and knew who was doing the granting. Now I have a couple
> > > of
> > > roles I didn't create and need to know what has been granted to them.
> > > How
> > > do I find out without knowing who did the granting?
> > >
> > > Thank you, any help will be appreciated.
> > >
> > > Regina
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Regina Harter
> > > INET: rharter_at_emc-inc.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing
> > > Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Send FREE video emails in Yahoo! Mail!
> >http://promo.yahoo.com/videomail/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Regina Harter
> INET: rharter_at_emc-inc.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Johnston, Tim
> INET: TJohnston_at_quallaby.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Regina Harter
  INET: rharter_at_emc-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).