查看Oracle 用户状态SQL

List users

set pages 999 lines 100
col username    format a20
col status    format a8
col tablespace    format a20
col temp_ts    format a20
select    username
,    account_status status
,    created
,    default_tablespace tablespace
,    temporary_tablespace temp_ts
from    dba_users
order    by username
/

Lock or unlock a user

alter user account lock;

alter user account unlock;

Reset User password

alter user usrname identified by "newpassword";