Re: user public in grid control

From: Fabrizio Magni <fabrizio.magni_at_mycontinent.com>
Date: Fri, 14 Oct 2005 06:26:47 +0200
Message-ID: <434f3387$0$29548$4fafbaef@reader1.news.tin.it>

DA Morgan wrote:
> 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
>

Thank you but please, read the subject!

I know how to use the CLI.

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Thu Oct 13 2005 - 23:26:47 CDT