Re: user public in grid control

Fabrizio Magni wrote:

> I'm still puzzled on how to list public grants, synonyms, dblinks, etc...

SELECT from data dictionary views WHERE owner = 'PUBLIC';

For example:

SQL> selelect count(*)

   2 from dba_synonyms
   3 where owner = 'PUBLIC';

   COUNT(*)

      20688

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)