适用范围

Oracle 11G and laster

目标

Oracle 用户密码重置为当前密码，DBA并不知晓当前的密码

解决方案

一、Oracle user$表解释

SYS.USER$ table in Oracle – last password change time, last locked, last expired, creation time, failed logon Posted on August 22, 2016 Oracle internal table SYS.USER$ has got many interesting columns for DBAs. This article describes some of them.

Internal table SYS.USER$ keeps both users and roles. The table is basic table that enlist database users and is referenced by almost all other dictionary views.

  DESC sys.user$

Name         Null     Type           
------------ -------- -------------- 
USER#        NOT NULL NUMBER         
NAME         NOT NULL VARCHAR2(30)   
TYPE#        NOT NULL NUMBER         
PASSWORD              VARCHAR2(30)   
DATATS#      NOT NULL NUMBER         
TEMPTS#      NOT NULL NUMBER         
CTIME        NOT NULL DATE           
PTIME                 DATE           
EXPTIME               DATE