15.10 - MODIFY USER - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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