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

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
Get step-by-step solutions from verified subject matter experts
