16.20 - MODIFY USER - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

Changes system parameters assigned to the specified 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

Syntax