MODIFY PROFILE Examples | Teradata Vantage - 17.10 - Example: Modify profile spool space - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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.