RE: unlimited tablespace

From: Maheshwara Rao, L., Teki <teki01_at_mediaone.net>
Date: Sun, 18 Jun 2000 23:34:15 -0400
Message-Id: <10532.109669@fatcity.com>

Great idea!!!

Maheshwara Rao, L., Teki
E Mail : teki01_at_mediaone.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Dave Morgan 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 Sun Jun 18 2000 - 22:34:15 CDT