Non-DBA password expire notification.
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';