Archives of the TeradataForum
Message Posted: Fri, 08 Aug 2003 @ 12:23:22 GMT
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
CREATE USER USERA FROM USER_DATABASE
CREATE USER USERB FROM USER_DATABASE
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023