Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1) Assume the EMPLOYEE table has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD 38000 Terry 102 HR 60000 David 103 SALES 58000 Ellie 104 RD 70000 Judy a) Provide the complete PL/SQL code to implement a Virtual Private Database such that an employee could only view the records for employees in the same department while masking coworkers’ salary with NULL. b) Based on the Virtual Private Database you implemented in step a), would an employee be able to insert, update or delete a record for another employee who works in another department? If yes, what might be the potential security risk and how would you fix the problem by setting up the VPD appropriately?

1) Assume the EMPLOYEE table has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD 38000 Terry 102 HR 60000 David 103 SALES 58000 Ellie 104 RD 70000 Judy a) Provide the complete PL/SQL code to implement a Virtual Private Database such that an employee could only view the records for employees in the same department while masking coworkers’ salary with NULL. b) Based on the Virtual Private Database you implemented in step a), would an employee be able to insert, update or delete a record for another employee who works in another department? If yes, what might be the potential security risk and how would you fix the problem by setting up the VPD appropriately?

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 97C: The following tables provide a very small portion of the data that will be kept in the database....
See similar textbooks
icon
Related questions
Question

1) Assume the EMPLOYEE table has the following rows
ID DEPT SALARY NAME
100 SALES 40000 Smith
101 RD 38000 Terry
102 HR 60000 David
103 SALES 58000 Ellie
104 RD 70000 Judy
a) Provide the complete PL/SQL code to implement a Virtual Private Database such
that an employee could only view the records for employees in the same
department while masking coworkers’ salary with NULL.
b) Based on the Virtual Private Database you implemented in step a), would an
employee be able to insert, update or delete a record for another employee who
works in another department? If yes, what might be the potential security risk and
how would you fix the problem by setting up the VPD appropriately? 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS