Section courante

A propos

Section administrative du site

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