ALTER USER
ALTER USERusername
[IDENTIFIED {BYpassword
| EXTERNALLY | GLOBALLY} ] [DEFAULT TABLESPACEtablespace_name
] [TEMPORARY TABLESPACEtablespace_name
] [QUOTA [integer
[K | M] | UNLIMITED] ONtablespace_name
] [PROFILEprofile_name
] [DEFAULT ROLE { [role_name
[,role_name
...]] | [ALL [EXCEPTrole_name
[,role_name
...]]] | NONE} [PASSWORD EXPIRE] [ACCOUNT {LOCK | UNLOCK}
Changes the security and storage characteristics of a user (username).
Specifies that the password must be provided when enabling the role.
Specifies that the operating system verifies the user enabling the role.
Specifies that the Oracle Security Server verifies the user enabling the role.
Changes the name of the tablespace (tablespace_name) that will be used by default when this user creates a database object.
Changes the name of the tablespace (tablespace_name) that will be used for the creation of temporary segments for operations like sorting that require more memory than is available.
Specifies the amount of space this user is permitted to use for object storage in the specified tablespace. UNLIMITED means there is no limit to the storage used, subject to the total size of the tablespace.
Changes the user’s profile to profile_name, which subjects the user to the limits specified in that profile.
Specifies the roles assigned to the user as default roles. ALL means that all roles granted to the user will be default roles except those specified in the EXCEPT clause, and NONE means that none of the roles granted to the user will be default roles.
Causes the userid’s password to expire. It will have to be reset before the user can connect to the database.
Causes the account to be locked and disabled. The account will have to be unlocked with the ALTER USER .... ACCOUNT UNLOCK command.
Causes the account to be unlocked. This is the default.