Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Users vs. Schemas
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
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.orgReceived on Fri Jun 29 2007 - 16:15:07 CDT