Question: ALL DONE WITH SQL DEV PLEASE Create and execute SQL statements to perform the following actions, using the JustLee Books database: Create a new user

ALL DONE WITH SQL DEV PLEASE

Create and execute SQL statements to perform the following actions, using the JustLee Books database: Create a new user account. The account name should be a combination of your first initial and your last name.

Create and execute SQL statements to perform the following actions, using the JustLee Books database: Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.

Create and execute SQL statements to perform the following actions, using the JustLee Books database: Using an account with the required privileges, create a role named CUSTOMERREP that allows inserting new rows in the ORDERS and ORDERITEMS tables and deleting rows from these tables.

Create and execute SQL statements to perform the following actions, using the JustLee Books database: Log in to Oracle 12c with the new account created in Assignment 1. Determine the privileges currently available to the account.

Create and execute SQL statements to perform the following actions, using the JustLee Books database: Delete the CUSTOMERREP role from the Oracle 12c database.

Create and execute SQL statements to perform the following actions, using the JustLee Books database: Delete the user account created in Assignment 1.

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 Databases Questions!