Database Administration (MOSC)

MOSC Banner

Non-DBA password expire notification.

edited Oct 28, 2014 10:01AM in Database Administration (MOSC) 11 commentsAnswered

Is there an alternative to the sys.user$ table to perform the query for a ptime for non-DBA users, developers/generic ID's will not have any grants to the sys views/tables.

Ideally I would like to have application team/developer own the process with a weekly scheduled query with added logic to alert when the password is 15-30 days prior to the expiration date.

Currently I run the following sql to provide the pw expiration date for the application teams.

col "Last Changed" for a12

col "Password Expiration Date" for a25

SQL> select to_char(ptime,'MM/DD/YYYY') "Last Changed", to_char(ptime +90,'MM/DD/YYYY') "Password Expiration Date" from sys.user$ where name ='&USER_NAME';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center