AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Altered time3/12/2023 ![]() This statement causes the app_user account to become locked for one day after five unsuccessful login attempts.Ĭhanging Password Lifetime and Grace Period: Example The following statement modifies the profile app_user2 PASSWORD_LIFE_TIME to 90 days and PASSWORD_GRACE_TIME to 5 days: Limiting Login Attempts and Password Lock Time: Example The following statement alters profile app_user with FAILED_LOGIN_ATTEMPTS set to 5 and PASSWORD_LOCK_TIME set to 1: Setting Default Password Values: Example The following statement defaults the PASSWORD_REUSE_TIME value of the app_user profile (created in "Setting Profile Resource Limits: Example") to its defined value in the DEFAULT profile: Making a Password Unavailable: Example The following statement makes the password of the new_profile profile (created in "Creating a Profile: Example") unavailable for reuse for 90 days: Please refer to CREATE PROFILE and to the examples in the next section for more information. You cannot remove a limit from the DEFAULT profile. The keywords, parameters, and clauses in the ALTER PROFILE statement all have the same meaning as in the CREATE PROFILE statement. ( resource_parameters::=, password_parameters::=)ĭescription of the illustration resource_parameters.gifĭescription of the illustration password_parameters.gif To modify password limits and protection, you must have ALTER PROFILE and ALTER USER system privileges.ĭescription of the illustration alter_profile.gif You must have ALTER PROFILE system privilege to change profile resource limits. See Also: CREATE PROFILE for information on creating a profile
0 Comments
Read More
Leave a Reply. |