Setting Password Policy in Oracle 10g
Hi,
Could you guide me please? Up to date there has not been a Policy for passwords in our 10g Database which means the user can set anything for their password. We however now require to implement a Password Policy and would appreciate some guidance in doing this.
We don't use Enterprise Manager,we have chosen not to configure it on our system.
These are the steps I propose to take to set the password policy:
1. Edit $ORACLE_HOME/rdbms/admin/utlpwdmg.sql to change default profile values to desired values.
2. as SYS run utlpwdmg.sql
Is this correct? Is there anything else I should do?
thank you.