15.10 - Example: Modify profile spool space - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Assume user anderson has a spool setting of 500,000 bytes and user brewster has a spool setting of 800,000 bytes.

User anderson can create a profile named finance with a spool setting of 500,000 bytes.

     CREATE PROFILE finance AS 
     SPOOL = 500000;

User anderson can assign this profile to user brewster, effectively reducing the spool limit from 800,000 to 500,000 bytes.

     MODIFY USER brewster AS 
     PROFILE = finance;

If the owner of anderson later increases the spool allotment to 1,000,000, anderson can also increase the finance profile spool setting up to 1,000,000 bytes. All users assigned that profile, including brewster, automatically get 1,000,000 bytes of spool space.

     MODIFY PROFILE finance AS
     SPOOL = 1000000;

If the owner of anderson later decreases the spool allotment back to 500,000 bytes, the finance profile and the allotment for brewster are not affected.