I'm looking for a script that checks for Oracle passwords that are about
to expire and notifies the user/dba so that they can go ahead and change
the password.

I know in the profile I can set for grace period, but the jBoss
applications we are using will not be able to read any Oracle messages,
therefore I need a script to manage the password expiration.

Any help is appreciated,
thanks

Oracle LazyDBA home page