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
Post a Comment