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