Oracle 用户管理

Oracle 用户管理

73.2. User

73.2.1. Create user

create user userName identified by password; 
			

指定表空间

create user neo identified by 123456 default tablespace netkiller;
			

73.2.2. Drop user

drop user userName cascade; 
			

cascade 删除用户同时删除该用户所创建的对象。

73.2.3. Alter user

alter user neo default tablespace neo;			
			

73.2.4. 修改密码

输入 sqlplus /nolog 回车

$ sqlplus /nolog

SQL> conn /as sysdba

SQL> alter user system identified by "123456";
SQL> alter user sys identified by "123456";
SQL> alter user FINANCE identified by "123123" account unlock;

User altered.
			

account unlock 解锁账号

alter user backup identified by "passw0rd" account unlock;			
			

73.2.5. Reset Password 忘记密码重置密码

密码文件 orapwORACLE_SID 这里的SID是orcl，所以密码文件是 orapworcl

orapwd file=$ORACLE_HOME/dbs/orapworcl password=newpass