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