Alter User 命令
ALTER USER
user
IDENTIFIED
BY password [REPLACE old_password]
EXTERNALLY
GLOBALLY AS 'external_name'
DEFAULT TABLESPACE tablespace
TEMPORARY TABLESPACE tablespace
QUOTA
integer { K | M }
UNLIMITED
...
PROFILE profile
DEFAULT ROLE
role [,...]
ALL [ EXCEPT role [,...] ]
NONE
PASSWORD EXPIRE
ACCOUNT
LOCK
UNLOCK
...
use [,...] <proxy_clause>
关键词
描述
password
设置的新密码
old_password
已知的旧密码, 用于修改别人的密码，并且你没有 ALTER USER 系统权限
TEMPORARY TABLESPACE
指定临时表空间
proxy_clause
{ GRANT | REVOKE }
CONNECT THROUGH <proxy>
[ WITH
ROLE
role_name [,...]
ALL EXCEPT role_name [,...]
NO ROLES
]
[ AUTHENTICATED USING
PASSWORD
DISTINGUISHED NAME
CERTIFICATE
[ TYPE 'type' ]
[ VERTION 'version' ]
]
关键词
描述
GRANT
赋予权限
REVOKE
撤消权限