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: Users vs. Schemas

Re: Users vs. Schemas

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Jun 2007 14:15:07 -0700
Message-ID: <1183151627.536068@bubbleator.drizzle.com>


Mark D Powell wrote:

> But is there a consensus of how best to describe PUBLIC?
>
> HTH -- Mark D Powell --

I'll, again, refer to the data dictionary in hopes of answering it. Though obviously my statement is not authoritative.

SQL> SELECT type# FROM user$ WHERE name = 'PUBLIC';

      TYPE#


          0

SQL> SELECT name

   2 FROM user$
   3 WHERE type# = 0
   4 ORDER BY 1; NAME



AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLE
AUTHENTICATEDUSER
CONNECT
CSW_USR_ROLE
CTXAPP
DATAPUMP_EXP_FULL_DATABASE
DATAPUMP_IMP_FULL_DATABASE
DBA
DELETE_CATALOG_ROLE
EJBCLIENT
EXECUTE_CATALOG_ROLE
EXP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
GLOBAL_AQ_USER_ROLE
....

PUBLIC is a role.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jun 29 2007 - 16:15:07 CDT

Original text of this message

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