Oracle SQL Plus

A ROLE allows us to define a set of rights needed to perform a set of duties associated with a particular function or "role" in the organization. Write the following instruction using SQL scripts that will login as user and create a role To begin, log into your instance as the SYSTEM user with UTAR password .Create a new user called SCOTT with fes password. Grant with appropriate command to allow the user to connect with database. Create a new role named Managers by providing the password for the role. Run the SQL script in the file called 3Northwoods.sql. Grant the Managers role to allow access to the Location table for insert, update and delete. Allow the user SCOTT to access the Manager role. . Log in as a SCOTT user and list the data in Location table. . Revoke the role from the SCOTT user. (11 marks)