Question: Oracle SQL Plus A profile is a database object which used to set the limit to the database resources and define the database users behavior

Oracle SQL Plus

Oracle SQL Plus A profile is a database object which used to

A profile is a database object which used to set the limit to the database resources and define the database users behavior to prevent users from wasting the resources. Write the following instruction using SQL scripts that will login as user and create a custom profile then applied to the DIECS user To begin, log into your instance as the SYSTEM user with UTAR Write SQL script that will create a new profile named FES PROFILE that will do the following: o Change the jassword every 30 days. o Limit the overall connection time to 5 hours o Limit the number of failed login attempts to 5 in a row o Limit the time required to lock the password to 2 days o Allow the user 3 days to change the password after it expires. o Allow a previous password be reused after 30 days if the password already been changed 10 times. .Apply the SCOTT PROFILE to DIECS user (11 marks)

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!