oracle用户相关操作

查询oracle所有用户信息

SQL> select username,account_status,default_tablespace,temporary_tablespace,created from dba_users order by created desc;

USERNAME  ACCOUNT_STATUS  DEFAULT_TABLESPACE  TEMPORARY_TABLESPACE  CREATED
TEST4  OPEN  TEST4  TEST4_TEMP 2021-07-13 16:26:34
SXXWSSQ240704 OPEN  USERS TEMP  2021-07-04 16:18:04
SPYPQMYSPT240703  OPEN  USERS TEMP  2021-07-03 14:57:20

查询oracle当前用户信息

SQL> select username,account_status,default_tablespace,temporary_tablespace,created,expiry_date from user_users ;

USERNAME    ACCOUNT_STATUS    DEFAULT_TABLESPACE    TEMPORARY_TABLESPACE    CREATED    EXPIRY_DATE
YXHL    OPEN    YXHL    YXHL_TEMP    2021-12-04 19:34:02

修改用户密码

SQL> alter user demo identified by demo123;
用户已更改。

用户解锁

SQL> alter user demo account unlock;
用户已更改。