Thanks Kevin, I try this.
-----Original Message-----
From: Lewis Kevin
[mailto:oracledba-ezmlmshield-x69985032.[Email address protected]
Sent: Friday, September 30, 2005 9:11 AM
To: LazyDBA Discussion
Subject: notification of expiring passwords
Is this enough?
select username,expiry_date from dba_users where expiry_date between
(select
sysdate+5 from dual) and (sysdate+10 from dual);
Obviously you set the + params to whatever you require in days ahead
etc.
We would normally run this from a shell script and get the results
e-mailed to us.
> Kevin Lewis
> UNIX Analyst/Programmer
> Caerphilly County Borough Council
> Tel: 01443 863258
> [Email address protected]
>
>
>
------------------------------------------------------------------------
--------------------------------------------
'This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent
those of the Council. Finally, the recipient should check this email and
any attachments for the presence of viruses. The Council accepts no
liability for any damage caused by any virus transmitted by this email.'
'Mae'r e-bost yma ag unrhyw ffeiliau trosglwyddwyd ynddi yn gyfrinachol
ar gyfer defnydd yr unigolyn neu'r sefydliad cyfeiriwyd ati yn unig. Os
ydych wedi derbyn yr e-bost yma mewn camgymeriad rhowch wybod i reolwr
eich system.
Nodwch taw unrhyw sylwadau neu farn soniwyd amdanynt yn yr e-bost yma
ydi sylwadau a barn yr awdur ac nid yn angenrheidiol yn cynrychioli
rhai'r Cyngor. I orffen, dylid y person sy'n derbyn yr e-bost sicrhau
nad oes firws ynddi nac mewn unrhyw ddogfen sydd ynghlwm i'r e-bost.
Nid yw'r Cyngor yn derbyn unrhyw gyfrifoldeb am unrhyw ddifrod achoswyd
gan unrhyw firws trosglwyddwyd gan yr e-bost yma.'
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page