Copyright 2016 dengage Leaning. All Rights Reserved May not be copod Kanac·ce d
ID: 3733932 • Letter: C
Question
Copyright 2016 dengage Leaning. All Rights Reserved May not be copod Kanac·ce d pleated. in thier Editorial neview has deemed that any suppsd conent does not materially affect the vrW electronic rigssom d party content may be suppressed from the eBook andioe eChaptienis) n)hc nghe tonomove additantul com at at any time if.dsequent ngto mmatam rop.rc it. Hands-On Assignments 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 12c 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 253 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 12c 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 12c database. 10. Delete the user account created in Assignment 1 Advanced Challenge Use the JustLee Books database to perform the following activity: There are three major classifications for employees who don't work for the Information Systems Department of JustLee Books: account managers, who are responsible for the company's marketing activities (for example, promotions based on customers' previousExplanation / Answer
Answer.)
3.
GRANT CONNECT TO new_user;
GRANT CREATE TABLE TO new_user;
GRANT ALTER ANY TABLE TO new_userl
5.
GRANT CUSTOMERREP TO new_user;
6.
LOGIN using new_user account and query as below :
SELECT * FROM USER_SYS_PRIVS;
8.
REVOKE CUSTOMERREP TO new_user;