Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Science Create Users for the system using the employee information. There are two different types of users, Sales Employee and Manager. Sales employee can view invoices, update invoices (i.e. add/remove items from invoices), create payments but not deleting or editing them, view item’s id, name, available quantity, and sale price, but not other information about items. Also, can view customer Id and name only. Managers can view and edit all information in the database. - You need to create views and access control for these users Task “B” Deliverables : One DCL SQL script file for defining the views and granting/ revoking access to the user types above.

Science Create Users for the system using the employee information. There are two different types of users, Sales Employee and Manager. Sales employee can view invoices, update invoices (i.e. add/remove items from invoices), create payments but not deleting or editing them, view item’s id, name, available quantity, and sale price, but not other information about items. Also, can view customer Id and name only. Managers can view and edit all information in the database. - You need to create views and access control for these users Task “B” Deliverables : One DCL SQL script file for defining the views and granting/ revoking access to the user types above.

Information Technology Project Management
Information Technology Project Management
9th Edition
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Kathy Schwalbe
Chapter11: Project Risk Management
Section: Chapter Questions
Problem 1E
See similar textbooks
icon
Related questions
Question
Computer Science Create Users for the system using the employee information. There are two different types of users, Sales Employee and Manager. Sales employee can view invoices, update invoices (i.e. add/remove items from invoices), create payments but not deleting or editing them, view item’s id, name, available quantity, and sale price, but not other information about items. Also, can view customer Id and name only. Managers can view and edit all information in the database. - You need to create views and access control for these users Task “B” Deliverables : One DCL SQL script file for defining the views and granting/ revoking access to the user types above.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Business Analysis Strategies
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
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
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
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
SEE MORE TEXTBOOKS