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 Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com