How you would set up the security of the database to enforce

Assignment Help Computer Engineering

Reference no: EM132142249

Question :

Suppose you have a table, EMPLOYEE, with the following attributes: eid, work_title, fname, lname, ssn, salary, date_of_birth, and commission_rate.

Ms. Smith is vice president of sales. She and three regional sales managers oversee the sales force and need to know the name of each employee whose work title is 'salesperson' along with each salesperson's salary and commission. Ms. Smith and her managers are not allowed to know the ssn or birthday of salespersons.

Only Ms. Smith is allowed to change the commission rate of salespersons. Mr. Jones works in the president's office and is in charge of sending birthday cards to each employee on their birthday. Mr. Jones only needs to see the name and birthday of employees.

Using roles, permissions (privileges), and views describe how you would set up the security of the database to enforce the restrictions described. You must use at least one role.

You must use at least one view. You must assign appropriate permissions.

Reference no: EM132142249

Questions Cloud

Interest tac shield : By what amount does the interest tac shield from its debt lower COWCOW's WACC?

Discuss the role of a central bank in a country : Discuss the role of a central bank in a country, particularly in implementing monetary policy. Comment on any regulatory requirements

What is cowcow pre-tac wacc : A) What is COWCOW pre-tac WACC? _____% (Round to two decimal places) B) What is COWCOW (effective after-tax) EACC? ____% (Round to two decimal places)

Present value of the interest tax shields : What is the present value of the interest tax shields from this debt? The present value of the interest tax shields is $___ million.

How you would set up the security of the database to enforce : describe how you would set up the security of the database to enforce the restrictions described. You must use at least one role.

What would be the monthly mortgage payment : The down payment is 20 percent and the balance is to be financed at 9 percent p.a. over the next 30 years. What would be the monthly mortgage payment

What is the expected return and standard deviation : (a) What is the expected return and standard deviation of a portfolio that is 100% invested in the risk-free asset?

Find the probability that a given user is transmitting : Find the probability that a given user is transmitting. Suppose now there are three users.

How much interest is paid in the third year : Prepare a amortization schedule for a five-year loan of $71,000. The interest rate is 7 percent per year, and the loan calls for equal annual payments.

User Account

All Pages