Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: user public in grid control

Re: user public in grid control

From: Fabrizio Magni <fabrizio.magni_at_mycontinent.com>
Date: Wed, 12 Oct 2005 13:29:13 +0200
Message-ID: <434cf38a$0$2422$892e7fe2@authen.white.readfreenews.net>


sybrandb_at_yahoo.com wrote:
> PUBLIC has never been a true schema. Frankly, there is only the user
> PUBLIC with a fixed id, which is hardcoded in all dictionary view
> definitions.
> (SYS=1, PUBLIC=2)
>

Ok, but the "schema" is visible and can be administer via java console.

Not so with the HTML interface of 10gR1 (or at least I wasn't able to). PUBLIC is not even listed amongst the users.

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

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe
Received on Wed Oct 12 2005 - 06:29:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US