Question: 1 . Connect to SYS user as DBA. 2 . Create a password complexity function ( named as cit 5 1 6 password ) to

1. Connect to SYS user as DBA.
2. Create a password complexity function (named as cit516password) to enforce the following requirements so that the password :
at least six (6) characters long
different from the user name
has at least one alpha, one numeric, and one punctuation mark character
Punctuation list: !#$%&()*+,-/:;<=>?_
not simple or obvious, as welcome, account, oracle, database, or user.
different from the previous password by at least 3 characters
Please note the exact spelling on the function name is REQIRED. Please also test your function.
3. Create a profile named cit516prof with the following specifications. Please note the exact spelling on the profile is REQIRED.
Number of days the password is valid before it is aged out. 90 days
Number of days ahead of expiration the user is warned about the password expiration. 15 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 1 days
PASSWORD_VERIFY_FUNCTION cit516password

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 Programming Questions!