$($a$)$ 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. List SIX $(6)$ password management policies discussed

in the class. Describe each functionality of this policies.

$(12$ marks$)$

$($b$)$ 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

password.

create a new profile named FES$\_$PROFILE that will do the following:

Limit the number of failed login attempts to $5$ in a row.

Limit the time required to lock the password to $1$ minute.

Change the password every $5$ minutes.

Allow the user $72$ hours to change the password after it expires.

Allow a previous password be reused after $30$ minutes if the

password already been changed $5$ times.

Create user FES with ORACLE password and DEFAULT profile.

Create grant CONNECT, GRANT ANY PRIVILEGES and

UNLIMITED TABLESPACE to the FES user.

Write SQL script that will apply the SCOTT$\_$PROFILE to DIECS user.