Step 1: write and execute the SQL code necessary to create these table (note see school example attached).

Lab Exercise 1

Based upon the relations shown below generate and run Oracle SQL queries to create the appropriate level of security for each scenario.

Step 1: write and execute the SQL code necessary to create these table (note see school example attached).

STUDENT

STUDENTID NAME MAJOR STATUS ADDRESS GPA
100 ABLE HISTORY SR 1 UTAH 3.00
200 BAKER ACCOUNTING JR 2 IOWA 2.70
300 CHARLES MATH SR 3 MAINE 3.50
400 DRAKE COMPUTER SCIENCE FR 4 IDAHO 2.80
500 ELLIOT COMPUTER SCIENCE SM 5 NEVADA 3.25
FACULTY

FACULTYID NAME DEPARTMENT ADDRESS RANK
0980 MARTIN IM 11 MAIN DEAN
5430 SEAVER IS 12 SOUTH PROFESSOR
7650 LOONEY IT 14 NORTH INSTRUCTOR
9870 MILLS SA 16 EAST LECTURER
OFFERING

OFFERINGNUM COURSENUM FACULTYID TERM YEAR TIME
1111 IS320 5430 FALL 2012 10 AM
1233 IS320 0980 FALL 2012 11 AM
2222 IS460 7650 SPRING 2013 10 AM
3333 IT480 5430 SPRING 2013 11 AM
ENROLLMENT

OFFERINGNUM STUDENTID
1111 100
1233 500
2222 300
3333 400
Using account in which you have DBA privilege, complete the following steps:

Step 2: Write and execute the SQL code necessary to Create User Accounts with passwords for All Students and Faculty.

Step 3: Write and execute the SQL code necessary to Grant the following access modes to the Users and Tables as indicated below:

TABLE USER PRIVLEDGE
STUDENT ABLE SELECT
STUDENT BAKER SELECT, UPDATE
STUDENT CHARLES SELECT, INSERT
STUDENT DRAKE SELECT, DELETE
STUDENT ELLIOT SELECT, UPDATE ON MAJOR ONLY
FACULTY MARTIN SELECT, UPDATE
FACULTY SEAVER SELECT, INSERT, DELETE
FACULTY LOONEY SELECT, UPDATE ON ADDRESS ONLY
FACULTY MILLS SELECT, UPDATE, INSERT
Step 4: Write and execute the SQL code necessary to Grant Create Session (or Connect if you have problems with Create Session) to each User

Step 5: Write and execute the SQL code necessary to demonstrate the access that each user has and to show they do not have other access rights, i.e., log on (connect) as each User and Demonstrate that the user has the access as indicated in the table and does not have any other access (e.g., log on as Able and show that able can select from student, but cannot update on student; then log on as Baker, Charles, etc. and show that Baker, Charles, etc. can select from student, etc. Note if a user las 2 or 3 privileges demonstrate that they can do all of them)

Remember for Able to access a table created by another user you must either create a synonym or qualify the table name e.g., DBST_USER.student. .

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our Guarantees

Money-back Guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism Guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision Policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy Policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation Guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: