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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How Does user have unlimited tablespace privilege?

RE: How Does user have unlimited tablespace privilege?

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Tue, 13 Jun 2000 15:23:28 -0400
Message-Id: <10527.109056@fatcity.com>


close but not quite right. The unlimited tablespace priv is the only system priv that cannot be granted to a role. BUT it is implicitly granted when the resource or dba role is granted.

So grant resource then revoke unlimited tablespace.

> -----Original Message-----
> From: Terry Ball [mailto:terry_ball_at_csgsystems.com]
> Sent: Tuesday, June 13, 2000 12:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How Does user have unlimited tablespace privilege?
>
>
> The resource priv contains the unlimited tablespace. If you don't
> want a user to have unlimited tablespace, do NOT grant resource.
>
> Terry
>
> Jeff Wiegand wrote:
>
> > Hello.
> >
> > I create my users in the following manner:
> >
> > create user user_name1 identified by user_name1 default
> tablespace users
> > temporary tablespace temp quota 0 on system quota unlimited on users
> > ;
> >
> > grant resource, connect to user_name1
> > ;
> >
> > The user then has the system privilege unlimited
> tablespace. If I do not
> > revoke this privilege, any dump for the user (from another
> database) is put
> > into the system tablespace. No, the user I get the dump
> from does not have
> > ANY objects in system. The user I get the dump from has a
> tablespace default
> > set to users as well, along with quota 0 on system.
> >
> > Why is the dump put into the system tablespace?
> >
> > Thanks.
> > --
> > Author: Jeff Wiegand
> > INET: jwiegand_at_ancept.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Author: Terry Ball
> INET: terry_ball_at_csgsystems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 13 2000 - 14:23:28 CDT

Original text of this message

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