Oracle Database – Password Policy Setting

During an Oracle installation, system will will be creating an default profile to store all its database settings. This settings will be always defaulted to default settings.

Some of the Oracle Forms build application uses this functionality to store its password configuration.

To customize the Oracle Profile we might need to create a new profile and tag the resources with a different values.

To do this, list all the resources and values available in the “DBA_PROFILES” and change the values based on your requirement for a profile value

select * from dba_profiles

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s