Allows a PLSQL password complexity verification script

Allows a plsql password complexity verification script

This preview shows page 81 - 90 out of 110 pages.

PASSWORD_VERIFY_FUNCTION Allows a PL/SQL password complexity verification script to be passed as an argument to the CREATE PROFILE statement. How to Create a Profile
Background image
Altering a Profile: Password Setting ALTER PROFILE default FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LIFE_TIME 60 PASSWORD_GRACE_TIIME 10;
Background image
The ALTER PROFILE command is used to change the password limits assigned to a profile: ALTER PROFILE profile LIMIT [ FAILED_LOGIN_ATTEMPTS max_value ] [ PASSWORD_LIFE_TIME max_value ] [ { PASSWORD_REUSE_MAX max_value ] | PASSWORD_REUSE_TIME } max_value ] [ PASSWORD_LOCK_TIME max_value ] [ PASSWORD_GRACE_TIME max_value ] [ PASSWORD_VERIFY_FUNCTION { function | NULL | DEFAULT } ] If you want to set the password parameters to less than a day: 1 hour : PASSWORD_LOCK_TIME = 1/24 10 minutes : PASSWORD_LOCK_TIME = 10/1400 5 minutes : PASSWORD_LOCK_TIME = 5/1400 Altering a Profile
Background image
Dropping a Profile : Password Setting DROP PROFILE developer_prof; DROP PROFILE developer_prof CASCADE;
Background image
Drop a profile using the DROP PROFILE command: DROP PROFILE profile [CASCADE] profile: is the name of the profile to be dropped CASCADE: revokes the profile from users to whom it is assigned (The database server automatically assigns the DEFAULT profile to such users. Specify this option to drop a profile that is currently assigned to users.) Guidelines The DEFAULT profile cannot be dropped. When a profile is dropped, this change applies to subsequently created sessions only and not to the current sessions. Dropping a Profile
Background image
Resource Management Resource management limits can be enforced at the session level, the call level, or both. Limits can be defined by profiles using the CREATE PROFILE command. Enable resource limits with the: RESOURCE_LIMIT initialization parameter ALTER SYSTEM command
Background image
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( and stopping and restarting the instance). Enforcing the resource limits is not required for enabling database password management. Steps for Using Resource Limits
Background image
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;
Background image
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).
Background image

Want to read all 110 pages?

Image of page 90

Want to read all 110 pages?

You've reached the end of your free preview.

Want to read all 110 pages?

  • Spring '15
  • dawan
  • Foreign key, database server, Constraint

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture