Re: User PUBLIC questions

From: Michael J. Moore <NOhicamelSPAM_at_comcast.net>
Date: Sun, 30 Nov 2003 16:30:41 GMT
Message-ID: <RWoyb.368319$Tr4.1080913@attbi_s03>

Sho enuf!
1* select user#, name, type# from sys.user$ where rownum < 7 SQL> /

     USER# NAME                                TYPE#
---------- ------------------------------ ----------
         0 SYS                                     1
         1 PUBLIC                                  0
         2 CONNECT                                 0
         3 RESOURCE                                0
         4 DBA                                     0
         5 SYSTEM                                  1

6 rows selected.

It's a type 0 user just like all of the other ROLEs. So, I wonder why OEM treats it like a user when it has more of the characteristics of a ROLE. (Just thinking out loud here, not really expecting an answer).

yth
Mike

> Under the covers, users and roles are very very similar (both being
> stored in the same table if I recall correctly). Run a query from USER$
> as SYSDBA, so some "overlap" in what they do and don't do can probably
> be expected.
>
> hth
> connor
Received on Sun Nov 30 2003 - 10:30:41 CST