15.10 - MODIFY USER - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Release Date
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

Purpose

Changes system parameters assigned to the specified user.

Required Privileges

IF you are … THEN you must have the DROP USER privilege on …
not the user being modified the referenced user.
the user being modified yourself 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 need not have DROP USER on yourself to change any 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. SeeMODIFY 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