Changes system parameters assigned to the specified user.
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.
|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
- DROP TABLE