Question: Create an SQL script (Project8.sql ; See requirements below). The script performs the following: Drop all users (created as per bullet below) Drop all roles
Create an SQL script (Project8.sql ; See requirements below).
The script performs the following:
Drop all users (created as per bullet below)
Drop all roles ( created as per bullet below)
Creates ten users (user1 user10) password the same as user name
Create a role, "EmployeeRole" that contains privileges to perform the following tasks
Create Table
Create Any Index
Create View
Create Sequence
Assign the role to each of the users
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
