Tuesday 15 July 2014

Check When MY Oracle Password Expires -



Check When MY Oracle Password Expires -

i have non-admin login oracle database, , i'd check when password expires. i've found lot of info online getting password expiration dates querying on dba_users table -- not have privileges view table.

i'm hopeful oracle includes way me check password expiration own login, far i've been unable find queries except reference dba_users table.

is there way me determine when own password expires without putting in ticket dba?

you can see current user details using

select * user_users;

that have column name "expiry_date" has info inquire for.

p.s. every dba_* there all_* (all permitted records current user can see) , user_* (all permitted records owned current user)

so dba_tables has tables systems has, all_tables has tables current user has permissions on (update, delete, insert, modify, etc), , user_tables - tables current user created.

oracle passwords

No comments:

Post a Comment