Oracle SQL Plus A profile is a database object which used to set the limit to th

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 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)

Explanation / Answer

Answer 1 ----open sqlprompt

connect system/UTAR

Answer 2

Suppose the script name is prof1.sql saved in d: of windows. Goto cmd prompt

notepad d:prof1.sql

CREATE PROFILE FES_PROFILE LIMIT
PASSWORD_LIFE_TIME 30
CONNECT_TIME 300
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 2
PASSWORD_GRACE_TIME 3
PASSWORD_REUSE_TIME 30
PASSWORD_REUSE_MAX 10;

save the file

Now come to sqlprompt

@d:prof1.sql

Answer3 --->Run from sql prompt

alter user DIECS profile SCOTT_PROFILE;

or

alter user DIECS profile FES_PROFILE;

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.