Re: [Q] how to check object or role grant to public?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 11 Feb 2003 10:22:30 -0800
Message-ID: <F001.00549B48.20030211102230@fatcity.com>

look at dba_tab_privs for object grants (this will include stored procedures)

look at dba_role_privs for roles

and read the manuals, you'd be amazed at how many questions can be answered by doing that

• dist cash <mccdba_at_hotmail.com> wrote:
  >
  > e have ORACLE 8.1.7 on SUN erver. My question are:
  >
  > 1. how to check which object or role are grant to public (from
  > DBA)?
  > (e.g. grant select on tax to public)
  >
  > 2. How to check which object or role are grant to which users?
  >
  > Thanks.
  >
  >
  >
  >
  >
  >
  >
  >
  > _________________________________________________________________
  > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
  > http://join.msn.com/?page=features/junkmail
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: dist cash
  > INET: mccdba_at_hotmail.com
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > 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!?
Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Tue Feb 11 2003 - 12:22:30 CST