Oracle 账号管理
73.1. Account
select username,account_status from dba_users; select username,account_status from dba_users where account_status='OPEN'; select username,account_status from dba_users t where t.default_tablespace = 'USERS' and t.account_status = 'OPEN';
73.1.1. show user
SQL> show user; USER is "SYS" SQL> select user from dual; USER ------------------------------ SYS
73.1.2. DEFAULT_TABLESPACE
用户默认表空间
SQL> SELECT DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME='WCUSER'; DEFAULT_TABLESPACE ------------------------------ WCSDB SQL> SELECT DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME=(select user from dual); DEFAULT_TABLESPACE ---------------