create user myuser identified by mypwd default tablespace USERS temporary tablespace TEMP profile DEFAULT; -- Grant/Revoke role privileges grant connect to myuser with admin option; grant dba to myuser with admin option; grant resource to myuser with admin option; -- Grant/Revoke system privileges grant unlimited tablespace to myuser with admin option;
SQL>create user abcd identified by abcd; 用户已创建 SQL>alter user abcd identified by abc; 用户已更改 我都能修改,你为什么不能?
IDENTIFIED BY system;
成功
alter user mp identified by MP;
失败
我的环境是NT+oracle8.1.5
修改密码的命令楼上已经给出了,下面给出一个完整的创建用户的命令,创建完不要忘记给他赋权限呀!
CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]
identified by mypwd
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to myuser with admin option;
grant dba to myuser with admin option;
grant resource to myuser with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to myuser with admin option;
用户已创建 SQL>alter user abcd identified by abc;
用户已更改
我都能修改,你为什么不能?
就是不能改,我也晕