Message-Id: <10527.108884@fatcity.com> From: ddorr.cs@clearstream.com Date: Tue, 13 Jun 2000 13:41:43 +0200 Subject: RE: How Does user have unlimited tablespace privilege? grant RESOURCE => unlimited tablespace > ---------- > From: Jeff Wiegand[SMTP:jwiegand@ancept.com] > Reply To: ORACLE-L@fatcity.com > Sent: Tuesday, June 13, 2000 00:35 > To: Multiple recipients of list ORACLE-L > Subject: How Does user have unlimited tablespace privilege? > > 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@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@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).