Password change date:- Find when was the password last changed


Here  SYS view user$ consists of  PTIME which means  what was the last time the password changed for the DBAUNIV user and CTIME is noting but creation date.

SELECT name,
ctime,
ptime
FROM sys.user$
WHERE name = 'DBAUNIV';


Thanks,
Mohammad.

Comments

Popular Posts