Tham khảo tài liệu 'oracle 8 database administration volume 2 instruction guide phần 7', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Administering Passwords Enabling Password Management Set up password management by using profiles and assigning them to users. Lock unlock and expire accounts using the CREATE USER or ALTER USER command. Password limits are always enforced even if RESOURCE_LIMlT for an instance is set to FALSE. 18-14 Copyright Oracle Corporation 1998. All rights reserved. ORACLE1 Similar to the resource limit settings create the profile to limit the password settings and assign them to the user by using the CREATE or ALTER USER command. However password limit settings in profiles are always enforced all other limits such as SESSIONS_PER_USER are enforced only when resource limits are enabled by the initialization parameter or the ALTER SYSTEM command. When password management is enabled the user account can be locked or unlocked by using the CREATE USER or ALTER USER command. Oracle8 Database Administration 18-21 Lesson 18 Managing Profiles Creating a Profile Password Settings CREATE PROFILE grace_5 LIMIT FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LIFE_TIME 30 PASSWORD_REUSE_TIME 30 PASSWORD_VERIFY_FUNCTION veri fy_function PASSWORD_GRACE_TIME 5 18-15 Copyright Oracle Corporation 1998. All rights reserved. ORACLE Use the following CREATE PROFILE command to administer passwords CREATE PROFILE profile LIMIT FAILED_LOGIN_ATTEMPTS max_value PASSWORD_LIFE_TIME max_value PASSWORD_REUSE_TIME PASSWORD_REUSE_MAX max_value ACCOUNT_LOCK_TIME max_value PASSWORD_GRACE_TIME max_value PASSWORD_VERIFY_FUNCTION function NULL default OEM 1 Use Security Manager. 2 Choose Profile Create. 3 In the Password Property sheet enter the account password parameters. 4 Click Apply. 18-22 Oracle8 Database Administration Administering Passwords Password Settings Parameter Description FAILED_LOGIN_ATTEMPTS Number of failed login attempts before lockout of the account PASSWORD_LOCK_TIME Number of days for which the account remains locked upon password expiration PASSWORD_LIFE_TIME Lifetime of the password in days after .
