[Solved]-Use Sql Developer Write Commands Sql Perform Task Justlee Books Wants Create Role Custome Q37188144

Use SQL Developer to write the commands in SQL to perform thetask below.

JustLee Books wants to create a role for customer servicerepresentatives. These employees need to be able to enter neworders and customers into the database as well as cancelling ormodifying existing orders. They need to be able to see the detailsabout each order, including the book, author, and publisherinformation. Please write the commands necessary to create the roleand give the role the necessary privileges for the appropriatetables. Think about what tables the employees will need to be ableto look at (SELECT), as well as those they will need to be able toUPDATE, DELETE or INSERT rows.

Expert Answer

---

Answer to Use SQL Developer to write the commands in SQL to perform the task below. JustLee Books wants to create a role for custo… . . .