How to get the last password changed time for a oracle user
Question: How to get the last password changed time for a oracle user? Answer: The SYS view user$ consists of a column PTIME which tells you what was the last time the password was changed for the user. Try this query: SELECT name, ctime, ptime FROM sys.user$ WHERE name = ' USER-NAME '; Note: Replace USER-NAME with the user name which you want to know the information. CTIME Indicates - Creation Time PTIME Indicates - Password Change Time Here's the table DESC ription: Name Type Nullable Default Comments ------------ ------------------- -------- ------- -------- USER# NUMBER NAME VARCHAR2(30 BYTE) ...