Briefly describe how password history works Password history checks ensure that

Briefly describe how password history works password

This preview shows page 4 - 5 out of 5 pages.

9) Briefly describe how password history works? 10) Briefly describe steps for using resource limits? Use the following steps to control the usage of resources with profiles: • Create a profile with the CREATE PROFILE command to determine the
Image of page 4
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( and stopping and restarting the instance). Enforcing the resource limits is not required for enabling database password management. Enabling 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; Controlling Enforcement of Resource Limits Enable or disable the enforcement of resource limits by altering the RESOURCE_LIMIT initialization parameter or by using the ALTER SYSTEM command. RESOURCE_LIMIT Initialization Parameter • To enable or disable enforcement of resource limits, alter this parameter in the initialization file and restart the instance. • A value of TRUE enables enforcement. • A value of FALSE disables enforcement (default). • Use this parameter to enable enforcement when the database can be shut down. ALTER SYSTEM Command • To enable or disable enforcement of resource limits for an instance, use the ALTER SYSTEM command. • The setting specified using the ALTER SYSTEM command remains in effect until altered again or until the database is shut down. • Use this command to enable or to disable enforcement when the database cannot be shut down.
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '16
  • Foreign key, Constraint, data integrity, resource limits

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture