Profile Characteristics Profile assignments do not effect current sessions. Profile can be assigned only to users and not to roles or other profiles. If you do not assign a profile when creating a user, the user is automatically assigned the DEFAULT profile ANSWER 7: Set up password management by using profiles and assign them to users. Lock, unlock, and expire accounts using the CREATE USER or ALTER USER command. Password limits are always enforced. ANSWER 8: The PASSWORD_LIFE_TIME parameter sets the maximum lifetime after which the password must be changed. The database administrator can specify a grace period PASSWORD_GRACE_TIME, which begins after the first attempt to log in to the database after password expiration. A warning message is generated every time the user tries to log in until the grace period is over.
ANSWER 10: Use the following steps to control the usage of resources with profiles:
Create a profile with the CREATE PROFILE command to determine the resource and password limits. Assign profiles with the CREATE USER or ALTER USER command. Enforce resource limits with the ALTER SYSTEM command or by editing the initialization parameter file. (Stopping the restarting the instance). Enforcing the resource limits is not required for enabling database password management. To Enable Resource Limits: Set the initialization parameter RESOURCE_LIMIT to TRUE Enforce the resource limits by enabling the parameter with the ALTER SYSTEM command ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
You've reached the end of your free preview.
Want to read all 8 pages?
- Spring '18
- Constraints, administrator, Database management system, Constraint