Profiles A profile is a named set of the following password and resource limits: Password aging and expiration Password history Password complexity verification Account locking CPU time Input/output (I/O) operations Idle time Connect time Memory space (private SQL area for Shared Server only) Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile of the user | Managing Password Security and Resources Objectives After completing this lesson, you should be able to do the following: Manage passwords using profiles Administer profiles Control use of resources using profiles Obtain password and resource limit information Profiles A profile is a named set of password and resource limits. Profiles are assigned to users by the CREATE USER or ALTER USER command. Profiles can be enabled or disabled. Profiles can relate to the DEFAULT profile. Profiles A profile is a named set of the following password and resource limits: Password aging and expiration Password history Password complexity verification Account locking CPU time Input/output (I/O) operations Idle time Connect time Memory space (private SQL area for Shared Server only) Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile of the user. Profiles (continued) The Oracle server automatically creates a DEFAULT profile when the database is created. The users who have not been explicitly assigned a specific profile conform to all the limits of the DEFAULT profile. All limits of the DEFAULT profile are initially unlimited. However, the database administrator can change the values so that limits are applied to all users by default. Profile usage Restrict users from performing some operations that require heavy use of resources. Make sure that users log off the database when they have left their session idle for some time. Enable group resource limits for similar users. Easily assign resource limits to users. Manage resource usage in large, complex multiuser database systems. Control the use of passwords Profile characteristics Profile assignments do not affect current sessions. Profiles 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 . | Managing Password Security and Resources Objectives After completing this lesson, you should be able to do the following: Manage passwords using profiles Administer profiles Control use of resources using profiles Obtain password and resource limit information Profiles A profile is a named set of password and resource limits. Profiles are assigned to users by the CREATE USER or ALTER USER command. Profiles can be enabled or disabled. Profiles can relate to the DEFAULT profile. Profiles A profile is a named set of the following password and resource limits: Password aging and expiration Password history Password complexity verification Account locking CPU time Input/output (I/O) operations Idle time Connect time Memory space (private SQL area for Shared Server only) Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile .
