Re: help! info about PUBLIC role

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 03 May 1999 09:14:07 -0700
Message-ID: <372DCB4F.46E92754@us.oracle.com>

Does PUBLIC have the RESOURCE role? UNLIMITED TABLESPACE is mapped to that role for some reason.

HTH. Pete

kal121_at_yahoo.com wrote:

> 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

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Mon May 03 1999 - 11:14:07 CDT