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:
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