MODIFY USER SQL Statement | Teradata Vantage - 17.10 - MODIFY USER - 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)

Changes system parameters assigned to the specified user.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Other SQL dialects support similar non-ANSI standard statements with names such as ALTER USER.

Required Privileges

User Performing Modification DROP USER Privilege Required For
Not the user being modified. Referenced user.
User being modified. You, if you are changing any of the following parameters:
  • PERMANENT
  • SPOOL
  • ACCOUNT
  • PROFILE

    To submit a MODIFY USER request that assigns or changes a profile, you must have the DROP PROFILE privilege.

The DROP USER privilege on yourself is not required to change other parameters.

To assign, change, or remove a row-level security constraint for a user, you must have the CONSTRAINT ASSIGNMENT privilege.

You cannot use MODIFY USER to modify a database. See MODIFY DATABASE.

Privileges Granted Automatically

If you submit a successful MODIFY USER DEFAULT JOURNAL TABLE request, the following privileges are granted automatically to the user on the journal table.
  • DROP TABLE
  • INSERT