Question: Lab Password Policy Your task is to develop a single SQL script that will perform all the following tasks of enforcing password complexity: 1. Connect

Lab Password Policy Your task is to develop a single SQL script that will perform all the following tasks of enforcing password complexity: 1. Connect to SYS user. 2. Create a password complexity function (named as "is481_password") to enforce the following requirements so that the password Is at least six (6) characters long Differs from the user name Has at least one alpha, one numeric, and one punctuation mark character Is not simple or obvious, such as welcome, account , oracle, database , or user. Differs from the previous password by at least 3 characters Please note the exact spelling on the function name is REQIRED. Please note the double quotation mark (") was not a part of the specified function name. 3. Create a profile named is481_prof with the following specifications. Please note the exact spelling on the profile is REQIRED. Test your code before submission. Number of days the password is valid before it is aged out. 60 days Number of days ahead of expiration the user is warned about the password expiration. 1 day Number of days before a password can be reused. 30 days Number of times a password can be reused. UNLIMITED Number of failed login tries allowed before the account is locked. 3 Number of days an account is locked due to failed login tries 13 days PASSWORD_VERIFY_FUNCTION is481_password 4. Assign the above profile to user DBSEC that you have already created. (15 points) Tips: 1. One SQL(PL/SQL) file is required to complete all the above tasks. 3. Typical syntax on connecting to SYS is: "conn sys/password as sysdba;"

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!