The resource priv grants unlimited tablespace to the user. So grant
resource and revoke unlimited tablespace, then if u want u can grant
unlimited tablespace on specific tablespace for the perticular user.
> -----Original Message-----
> From: Adams, Matthew (GEA, 088130) [SMTP:MATT.ADAMS_at_APPL.GE.COM]
> Sent: Wednesday, June 14, 2000 12:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How Does user have unlimited tablespace privilege?
>
> 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).
> >
> --
> Author: Adams, Matthew (GEA, 088130)
> INET: MATT.ADAMS_at_APPL.GE.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
Received on Wed Jun 14 2000 - 00:43:12 CDT
