Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎专栏 | Search | Email

9.2. User

9.2.1. Create user

create user userName identified by password; 
			

指定表空间

create user neo identified by 123456 default tablespace netkiller;
			

9.2.2. Drop user

drop user userName cascade; 
			

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

9.2.3. Alter user

alter user neo default tablespace neo;			
			

9.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;			
			

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

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

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