Profile characteristics profile assignments do not

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;