Re: database privileges

Why do so difficult?

SQL> grant dba to public;

Grant succeeded.

SQL> select * from dba_role_privs
  2 where grantee = 'PUBLIC';

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
PUBLIC                         DBA                            NO  YES

--
Terry Dykstra
Canadian Forest Oil Ltd.
<kenneth.koenraadt_at_no-spam.hotmail.com> wrote in message
news:3db5189a.1690530_at_news.mobilixnet.dk...


> On Mon, 21 Oct 2002 19:20:39 +0200, Sybrand Bakker

> <gooiditweg_at_sybrandb.demon.nl> wrote:

>

> >On 21 Oct 2002 09:39:05 -0700, oil1can_at_yahoo.com (mark) wrote:

> >

> >>What are the default privileges granted to public from users sys and

> >>system, and what privileges does public really need ?

> >>I am trying to create a user with a minimum of rights and privileges,

> >>and want to know what minimum specific grants and privileges from sys

> >>and system I can get by with.

> >>Thanks,

> >>Mark

> >

> >

> >select * from dba_tab_privs where grantee = 'PUBLIC'

> >and

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

> >

> >should give you the results.

>

> Nope.

>

> Not if the privileges granted to PUBLIC were granted through roles.

> Something (stupid, yes, but not uncommon...) like

>

>                   grant DBA to public;

>

> would not be discovered by your query.

>

> There is nothing else to do than to loop recursively through

> dba_sys_privs, dba_role_privs and dba_tab_privs. Regret.

>

>

>

> - Kenneth Koenraadt

>

>

>

>

>

> >Regards

> >

> >

> >Sybrand Bakker, Senior Oracle DBA

> >

> >To reply remove -verwijderdit from my e-mail address

>