Check When MY Oracle Password Expires

Completing the previous answer

select USERNAME,EXPIRY_DATE from USER_USERS;

will give you the same result but with less clustered and easier to read output.

I have been looking for a very detailed answer to this question for quite some time and now I finally found an answer.

If you would like to know EXACTLY when your password expires, use this:

alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select username, expiry_date from user_users where username='my_username';

You will get results not just in date, but also in exact time.

You can see the current user details using

select * from USER_USERS;

That will have a column name "expiry_date" which has the data you ask for.

P.S. For almost every DBA_* there is an ALL_* (all the permitted records that the current user can see) and a USER_* (all the permitted records owned by the current user)

so DBA_TABLES has all the tables the systems has, ALL_TABLES has all the tables the current user has permissions to do something on (update, delete, insert, modify, etc), and USER_TABLES - all the tables the current user created.