MODIFY USER SQL Statement | VantageCloud Lake - MODIFY USER - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.

You do not need the DROP USER privilege 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
Related information