Re:How Does user have unlimited tablespace privilege?

From: <dgoulet_at_vicr.com>
Date: Tue, 13 Jun 2000 09:24:46 -0400
Message-Id: <10527.108909@fatcity.com>

Jeff,

    The oops happened when you granted him resource priviledge, it has the unlimited tablespace system priviledge attached. To get away from that I create a "developer" role in my databases that is almost, but not identical to, resource. Revoke the unlimites tablespace system priviledge & all will be well.  Might help to export that user, drop him & recreate his account to get a nice cleanup.

____________________Reply Separator____________________

Subject: How Does user have unlimited tablespace privilege? Author: Jeff Wiegand <jwiegand_at_ancept.com> Date: 6/12/00 2:35 PM

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).

Received on Tue Jun 13 2000 - 08:24:46 CDT