RE: Grants to PUBLIC

From: Ruiz, Mary A (CAP, CDI) <Mary.Ruiz_at_gecapital.com>
Date: Mon, 25 Sep 2000 16:29:59 -0400
Message-Id: <10630.117804@fatcity.com>

Select * from dba_tab_privs where grantee =3D 'PUBLIC';

Mary Ruiz
Atlanta GA

-----Original Message-----
From: Boivin, Patrice J=20
Sent: Monday, September 25, 2000 4:41 PM To: Multiple recipients of list ORACLE-L Subject: Grants to PUBLIC

Hi, hopefully there is an easy way to do this.

How can I generate a list of object grants to PUBLIC?

PUBLIC doesn't show up as a user or a role.

Thanks.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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). Received on Mon Sep 25 2000 - 15:29:59 CDT