diff_months: 19

Oracle’s Authorization System

Download Solution Now
Added on: 2022-11-15 06:01:31
Order Code: CLT308286
Question Task Id: 0
  • Country :

    United Kingdom

Chapter 8 - Laboratory Exercise: Exploring Oracle’s Authorization System

 Step 8.1 - Open the text file called:

Chapter_8_Laboratory_Exercise_DDL_forWorkerDeptProjectAssign.txt

 Step 8.2 - Create the Worker, Dept, Project, and Assign tables in the database.

To help you see how the commands work, open both the text file and the SQL*Plus window in Oracle. You will move back and forth between the open windows. You should highlight and copy the CREATE TABLE commands (one at a time) and paste them into SQL*Plus at the SQL> prompt. You should see the message: Table Created after each statement is executed. Show your work by providing screenshots of executing the CREATE TABLE SQL statements in the database.

 Step 8.3 – Run the Insert and Update commands for the four tables.

To do this, copy each INSERT and UPDATE command (one at a time) and paste them into SQL*Plus at SQL> prompt. For inserted rows, you should see the message:  1 row created after each statement is executed. For updated rows, you should see the message:  1 row updated after each statement is executed. Show your work by providing screenshots of executing the INSERT and UPDATE SQL statements in the database.

 Step 8.4 - For each step: Draw an authorization graph using a drawing tool, showing the privileges given. Design SQL statements that will be executed in the database. Then execute the SQL statements in the database.

Note: Each step should include an authorization graph. Hand-written authorization graphs are not acceptable submissions.

Note: Show your work by providing screenshots of executing the SQL statements in the database along with the results.

Step 8.4.a - Create five users: U100, U200, U300, U400, and U500.

Step 8.4.b - Give user U100 the SELECT, INSERT, DELETE, UPDATE privileges on all four tables, with grant option.

Step 8.4.c - Connect as U100 and pass the SELECT privilege on all four tables to u200 and U300, with grant option.

Step 8.4.d - Still acting as U100, pass the DELETE privilege on Project to U400 and U500, without the grant option

Step 8.4.e - Connect as U200 and pass the SELECT privilege on Project to U400 and U500, without the grant option.

Step 8.4.f - Connect as U100 and revoke all of the privileges that you granted to u200.

Step 8.4.g - From the authorization graph, determine and write out what privileges, if any, the remaining users should still have.

Step 8.4.h – As SYS Oracle ID, confirm the privileges in the database by selecting the table privileges for each user from the sys.dba_tab_privs data dictionary view.

  • Uploaded By : Katthy Wills
  • Posted on : November 15th, 2022
  • Downloads : 0
  • Views : 189

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more