Archives of the TeradataForum

Message Posted: Fri, 08 Aug 2003 @ 12:23:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Prior to the introduction of Profiles in V2R5 you could group like users under an database owner databases defining SPOOL and TEMPORARY space limits at the database level.

Consider this example:

CREATE DATABASE USER_DATABASE FROM DBC
AS PERM = 0, SPOOL = 10e6, TEMPORARY = 10e6;

CREATE USER USERA FROM USER_DATABASE
AS PERM = 0, PASSWORD = xyz;

CREATE USER USERB FROM USER_DATABASE
AS PERM = 0, PASSWORD = abc, SPOOL = 5e6;

USERA is a child of USER_DATABASE and will inherit SPOOL and TEMPORARY space of 10e6 bytes. USERB will also be owned by USER_DATABASE and will inherit TEMPORARY space from USER_DATABASE but will have a SPOOL limit of 5e6 bytes.

	<Prev	Next>		<<First	<Prev	Next>	Last>>