Re: help! info about PUBLIC role

From: <kal121_at_yahoo.com>
Date: Fri, 30 Apr 1999 19:47:29 GMT
Message-ID: <7gd1cg$b9m$1@nnrp1.dejanews.com>

Thanks for the reply. What I'm really looking for is where does it say that PUBLIC has the "UNLIMITED TABLESPACE" privilege? I know it is out there somewhere, because all of my new users get unlimited tablespace by default.

This is what I get when I run the scripts:

  1* select distinct privilege from dba_tab_privs where grantee = 'PUBLIC' SQL> / PRIVILEGE

---

DELETE
EXECUTE
INSERT
SELECT
UPDATE SQL> select * from dba_role_privs where grantee = 'PUBLIC';

no rows selected

SQL> select * from dba_sys_privs where grantee = 'PUBLIC';

no rows selected

Thanks.

---

In article <925490163.2439.0.rover.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> -- object privileges granted to public
> select * from dba_tab_privs
> where grantee = 'PUBLIC';
> -- roles granted to public
> select * from dba_role_privs where grantee = 'PUBLIC';
> -- system privileges granted to public
> select * from dba_sys_privs where grantee = 'PUBLIC';
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> kal121_at_yahoo.com wrote in message <7gcj25$ua4$1_at_nnrp1.dejanews.com>...
> >Where can one find information about the PUBLIC role in the data
> dictionary??
> >
> >I need to find out what's been assigned to public.
> >
> >Thanks
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 30 1999 - 14:47:29 CDT