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)