Develop a single SQL script that will perform all the following tasks of enforcing password complexity:

1. Connect to SYSTEM user. 

 

2. Make a password complexity function (named as "inft6157_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 REQUIRED.

Please note the double quotation mark (") was not a part of the specified function name.

 

3. Make a profile named inft6157_prof with the following specifications. Please note the exact spelling on the profile is REQUIRED. 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	inft6157_password

4. Assign the above profile to user DBSEC that you have already created. 

Answer rating: 100% (QA)

To perform the tasks of enforcing password complexity in Oracle SQL you can follow these steps Please make sure you have the necessary privileges to c... View the full answer