Open your DBCONSOLE/DBASTUDIO under users u will notice something called profile use that for your cause.SURE/SAFE/EASY and OVER ALL HASSLEFREE. Deep > The 8.1.7 Administrator's Guide suggests that the DBA should > force users to change their passwords periodically. I cannot, however, > find command in the SQL Reference which automates this function. > Am I missing something? > > Thanks, > Peter Schauss > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------