Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Administering Profiles

Profile administration isn't likely something that will take up a lot of your time as a DBA. After you establish a set of profiles, they are usually stable until you determine that you need to add a new one for a business purpose. This section helps with your administration tasks when you need them.

Creating Profiles

You need to create a profile if you want to centrally maintain password rules in your database.

Setting Password Limits

The following command creates a profile that sets password limits and that can later be assigned to a user group that has been determined to require this given set of limits:

							CREATE PROFILE
							custom_grace_5
							LIMIT
							FAILED_LOGIN_ATTEMPTS 5
							PASSWORD_LOCK_TIME UNLIMITED
							PASSWORD_LIFE_TIME 90
							PASSWORD_REUSE_TIME ...