Create and execute SQL statements to perform the following actions, using the JustLee Books database: 1. Create

Question:

Create and execute SQL statements to perform the following actions, using the JustLee Books database: 

1. Create a new user account. The account name should be a combination of your first initial and your last name. 

2. Attempt to log in to Oracle 11g with the newly created account. 

3. Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table. 

4. 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. 

5. Assign the account created in Assignment 1 the CUSTOMERREP role. 

6. Log in to Oracle 11g with the new account created in Assignment 1. Determine the privileges currently available to the account. 

7. Revoke the privilege to delete rows in the ORDERS and ORDERITEMS tables from the CUSTOMERREP role. 

8. Remove the CUSTOMERREP role from the account created in Assignment 1. 

9. Delete the CUSTOMERREP role from the Oracle 11g database. 

10. Delete the user account created in Assignment 1.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 11G SQL

ISBN: 9781133947363

2nd Edition

Authors: Joan Casteel

Question Posted: