Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: mysterious question re: UNLIMITED TABLESPACE privilege

Re: mysterious question re: UNLIMITED TABLESPACE privilege

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 30 Apr 1999 20:50:07 +0200
Message-ID: <925498065.4364.0.spot.d4ee154e@news.demon.nl>


The unlimited tablespace privilege is granted to the resource role. This has been done for backwards compatibility with Oracle 6. Whenever you grant someone the resource role, that user will have unlimited tablespace privilege. Generally speaking you should avoid granting connect, resource and dba and grant less powerful privileges instead (create session only instead of connect etc) I know the average Oracle developer is still using connect, resource and dba

Generally speaking no system privileges have been granted to PUBLIC. If this has been done, they are in effect automatically. All privilege check done implicitly by Oracle check for the privilege being granted to public. Granting to public means everyone get this privilege automatically.

Hth,
Sybrand Bakker, Oracle DBA
kal121_at_yahoo.com wrote in message <7gcsp2$71b$1_at_nnrp1.dejanews.com>...
>I've run a few experiments; it seems that the UNLIMITED TABLESPACE
privilege
>(as well as the other PUBLIC privs?) as given by the "PUBLIC user group"
gets
>assigned to a new user when I grant them the "resource" role.
>
>Does anyone know why this is?
>
>In other words, aside from explicitly assigning the resource role, how
would I
>know when the PUBLIC privileges are in effect for any new user?
>
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 30 1999 - 13:50:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US