Question: 1 . Connect to SYS user as DBA. 2 . Create a password complexity function ( named as cit 5 1 6 password ) to
Connect to SYS user as DBA.
Create a password complexity function named as citpassword to enforce the following requirements so that the password :
at least six 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 characters
Please note the exact spelling on the function name is REQIRED. Please also test your function.
Create a profile named citprof 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. days
Number of days ahead of expiration the user is warned about the password expiration. day
Number of days before a password can be reused. days
Number of times a password can be reused. UNLIMITED
Number of failed login tries allowed before the account is locked.
Number of days an account is locked due to failed login tries days
PASSWORDVERIFYFUNCTION citpassword
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
