Most of the time we will encounter our database passwords used to expire after 180 days.
If we don’t have any security constraint then by using the below approach we can make them never expire.
Using profile, you can enforce a limit on resource utilization using resource limit parameters Also you can maintain database security by using password management feature. Using the below query we can know ,which profile is used by each user account:
SQL> SELECT USERNAME, PROFILE FROM DBA_USERS;
You can see all my SOA related user accounts are using “DEFAULT” profile.
To know all the details imposed on DEFAULT profile we have to use the below query.
SQL> select resource_name, limit from dba_profiles where profile=’DEFAULT’ and resource_type=’PASSWORD’;
As shown above all our passwords will expire in 180 days. So for setting them to never expire we have use the below query.