Oracle SQL Plus Write the following instruction using SQL scripts that will crea

Question

Oracle SQL Plus

Write the following instruction using SQL scripts that will create a new user and grant the role to the user Create a new user in your instance called FES identified by a password and assign the default profile to this user Assign the default tablespace users and temporary tablespace temp to the " Grant the necessary privilege to enable user to connect to the database. Now create a new profile fes_prof and set certain limitations to this profile, namely: Limit the number of times that a wrong password can be entered to 3 before the account is locked If the password exceeds the above limit, lock it for 3 days. Now assign the new profile to FES - Create a role 'Admin with the following privileges: o select, insert, update, delete on the tables location, student, faculty and term Grant the role 'Admin' to fes Verify that FES has acquired the necessary privilege. (15 marks)

Explanation / Answer

1) This statement will create a new user named FES which is identified by the password 'newPass123'.

CREATE USER FES IDENTIFIED BY newPass123;
2) Assigning the dafault tablesspace and temporary table space to user FES. Alter user command is used.

alter user FES
default tablespace users
temporary tablespace temp;
3) Granting necessary privilage to the user to work on database.

grant create table, create view to FES;

4) Creating a new profile fes_prof, whose password attempt is set to 3 and if the password attempts exceeds the given limit then locking period is set to 3. Create profile command is used.

create profile fes_prof limit
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 3;

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

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