本文共 741 字，大约阅读时间需要 2 分钟。

Oracle???????

?Oracle???????????????????????????????????????????

?????Oracle???????SQL?????????????

create user TEST identified by 123456 default tablespace users;

???????????????????

grant create session to TEST;

??????????123456?????????????

??????????????????????

alter user TEST identified by 123;

????????????????

???????????????????????????????????????

alter user TEST account lock;alter user TEST account unlock;

??????????????????????????????????

drop user TEST cascade;

??????????????????????

select * from dba_users

?????????????????????????????

select sid, serial#, username, osuser from v$session where sid = 18;

?????????????????

alter system kill session '18,44304';

????????????????????????????????????

???????????????????????