Question: Use SQL Developer or VS Code to write the commands to perform the task below. Then copy and paste your SQL statements into the submission

Use SQL Developer or VS Code to write the commands to perform the task below. Then copy and paste your SQL statements into
the submission box. (Note that you may not have enough privilege to actually create a role or assign privileges.) This assignment
should be completed by April 16.
JustLee Books wants to create a role for customer service representatives. These employees need to be able to enter new orders
and customers into the database as well as cancelling or modifying existing orders. They need to be able to see the details about
each order, including the book, author, and publisher information. Please write the commands necessary to create the role and give
the role the necessary privileges for the appropriate tables. Think about what tables the employees will need to be able to look at
(SELECT), as well as those they will need to be able to UPDATE, DELETE or INSERT rows. Don't forget to include any bridging tables
that might be necessary.
Use SQL Developer or VS Code to write the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!