ALTER USER |
Modifie l'utilisateur |
|---|---|
| Oracle Database SQL |
Syntaxe
|
ALTER USER username [ IDENTIFIED BY password [REPLACE old_password] IDENTIFIED EXTERNALLY IDENTIFIED GLOBALLY AS external_name DEFAULT TABLESPACE tablespace TEMPORARY TABLESPACE tablespace QUOTA int {K | M} ON tablespace QUOTA UNLIMITED ON tablespace PROFILE profile_name DEFAULT ROLE role [,role,...] DEFAULT ROLE ALL [EXCEPT role,...] DEFAULT ROLE NONE PASSWORD EXPIRE ACCOUNT {LOCK|UNLOCK} ] ALTER USER username,... {GRANT|REVOKE} [ CONNECT THROUGH proxy [WITH ROLE role_name,...] [AUTHENTICATED USING [PASSWORD | DISTINGUISHED NAME | CERTIFICATE [TYPE 'type'] [VERSION 'version']]] CONNECT THROUGH proxy [WITH ROLE ALL EXCEPT role_name,...] [AUTHENTICATED USING [PASSWORD | DISTINGUISHED NAME | CERTIFICATE [TYPE 'type'] [VERSION 'version']]] CONNECT THROUGH proxy [WITH NO ROLES] [AUTHENTICATED USING [PASSWORD | DISTINGUISHED NAME | CERTIFICATE [TYPE 'type'] [VERSION 'version']]] ] |
Description
Cette instruction permet d'effectuer la modification d'un compte utilisateur de la base de données.
Voir également
Article - Les géants de l'informatique - Oracle
Dernière mise à jour : Lundi, le 11 mai 2015