17.10 - Example: Modifying Password, Spool Allocation, Startup String, and Default Database - 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)

You do not need access privileges to change your own PASSWORD, STARTUP, FALLBACK, or DEFAULT DATABASE definitions. Otherwise, the user submitting a MODIFY request must have the DROP privilege on the user being modified.

For example, although user Marks is not the creator of his own space and does not own himself, he can submit a MODIFY USER request to change his password, modify his startup string, or redirect his default database. Marks can resize finance, as well.

Change the password and other options on user marks.

     MODIFY USER marks AS 
     PASSWORD = design,
     SPOOL = 1500000, 
     STARTUP = 'EXEC paystat;',
     DEFAULT DATABASE =  payroll;