Oracle 常用账号密码维护

 1，检查用户状态

SQL> select username,account_status from dba_users;

USERNAME           ACCOUNT_STATUS
------------------------------ --------------------------------
OPS$SAPSERVICEPRD        OPEN
HS_AWS_SA          OPEN
OPS$PRDADM           OPEN
OPS$ORAPRD           OPEN
SYS            OPEN
SYSTEM             OPEN
SAPSR3             OPEN
OUTLN            EXPIRED
TSMSYS             EXPIRED & LOCKED
DIP            EXPIRED & LOCKED
DBSNMP             EXPIRED & LOCKED

11 rows selected.

SQL> select name,astatus from user$;

NAME          ASTATUS
------------------------------ ----------
SYS         0
PUBLIC          0
CONNECT         0
RESOURCE        0
DBA         0
SYSTEM          0
SELECT_CATALOG_ROLE     0
EXECUTE_CATALOG_ROLE      0
DELETE_CATALOG_ROLE     0
EXP_FULL_DATABASE     0
IMP_FULL_DATABASE     0

NAME          ASTATUS
------------------------------ ----------
OUTLN         0
RECOVERY_CATALOG_OWNER      0
GATHER_SYSTEM_STATISTICS    0
LOGSTDBY_ADMINISTRATOR      0
AQ_ADMINISTRATOR_ROLE     0
AQ_USER_ROLE        0
GLOBAL_AQ_USER_ROLE     0
SCHEDULER_ADMIN       0
DIP         9
HS_ADMIN_ROLE       0
_NEXT_USER        0

NAME          ASTATUS
------------------------------ ----------
TSMSYS          9
OEM_ADVISOR       0
OEM_MONITOR       0
DBSNMP          9
OPS$ORAPRD        0
OPS$PRDADM        0
SAPSR3          0
SAPDBA          0
SAPCONN         0
OPS$SAPSERVICEPRD     0
HS_AWS_SA       0

33 rows selected.

 直接改用户状态为 open 状态

UPDATE USER$ SET ASTATUS=0 WHERE NAME='username';

 

SQL> select * from user_astatus_map;

   STATUS# STATUS
---------- --------------------------------
    0 OPEN
    1 EXPIRED
    2 EXPIRED(GRACE)
    4 LOCKED(TIMED)
    8 LOCKED
    5 EXPIRED & LOCKED(TIMED)
    6 EXPIRED(GRACE) & LOCKED(TIMED)
    9 EXPIRED & LOCKED
   10 EXPIRED(GRACE) & LOCKED

9 rows selected.

 2.用户密码

SQL> select username,password from dba_users;

USERNAME           PASSWORD
------------------------------ ------------------------------
OPS$SAPSERVICEPRD        EXTERNAL
HS_AWS_SA          778AA25BA738673E
OPS$PRDADM           EXTERNAL
OPS$ORAPRD           EXTERNAL
SYS            C9E7F55D84571021
SYSTEM             E7CE9CB256FDC817
SAPSR3             7548ADA1E0439E5D
OUTLN            4A3BA55E08595C81
TSMSYS             3DF26A8B17D0F29F
DIP            CE4A36B8E06CA59C
DBSNMP             E066D214D5421CCC

 修改用户密码为旧的密码，解除 EXPIRED 状态

SQL>alter user username identified by values 'E7CE9CB256FDC817';

 

'修改密码有效期，无限
 ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

'解锁username
 alter user [username] account unlock;