Oracle SCOTT用户相关

来源:百度文库 编辑:神马文学网 时间:2024/03/28 18:54:35
1、查证目前系统对于SCOTT用户的状态:

select * from dba_users where upper(username)='SCOTT';

ACCOUNT_STATUS:EXPIRED & LOCKED

 

2、解除对于SCOTT用户的锁定:

conn sys/bitservice@ttonline as sysdba;

alter user scott account unlock;

select * from dba_users where upper(username)='SCOTT';

ACCOUNT_STATUS:EXPIRED

 

3、连接SCOTT用户:

conn scott/tiger@ttonline;提示该用户已经过期,请重新输入新的密码:tiger

conn scott/tiger@ttonline;此次可以正常连接此用户。

 

4、查看SCOTT用户的状态:

conn sys/bitservice@ttonline as sysdba;

select * from dba_users where upper(username)='SCOTT';

ACCOUNT_STATUS:OPEN