RE: unlimited tablespace

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Thu, 15 Jun 2000 09:57:11 -0400
Message-Id: <10529.109397@fatcity.com>

Wow, what a clever/elegant solution.

-----Original Message-----
From: Dave Morgan [mailto:dmorgan_at_bartertrust.com] Sent: Wednesday, June 14, 2000 12:55 PM
To: Multiple recipients of list ORACLE-L Subject: RE: unlimited tablespace

Hi All,

	Since unlimited tablespace cannot be granted to a 
	role we run the following on db creation.

	CREATE ROLE DATA_OWNER;
	GRANT CONNECT, RESOURCE to DATA_OWNER;

	Upon user creation:

	CREATE USER USER_NAME .....

	GRANT DATA_OWNER to USER_NAME

	This gives all the desired priviliges without UNLIMITED TABLESPACE.

	We do a similar thing with profiles.

	Having a standard set of roles and profiles reduces workload

immensely.
Dave
--

Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
408-982-8774
--

Author: Dave Morgan
  INET: dmorgan_at_bartertrust.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 Thu Jun 15 2000 - 08:57:11 CDT