You are a database developer for a large travel company. Information about each of the company’s departments is stored in a table named Department. Data about each of the company’s travel agents and department managers is stored in a table named Employees. The SQLLogin column of the Employees table contains the database login for the travel agent or department manager. The Department and Employees table are shown in the exhibit. Each department manager has been added to the Managers database role. You need to allow members of this database role to view all of the data in the department table. Members of this role should be able to insert or update only the row that pertains to their department. You grant the Managers database role SELECT permissions on the Department table. What should you do next?

239.

You are a database developer for a large travel company.
Information about each of the company’s departments is stored in a table named Department.
Data about each of the company’s travel agents and department managers is stored in a table named Employees.
The SQLLogin column of the Employees table contains the database login for the travel agent or department manager.
The Department and Employees table are shown in the exhibit.
Each department manager has been added to the Managers database role. You need to allow members of this database role to view all of the data in the department table. Members of this role should be able to insert or update only the row that pertains to their department. You grant the Managers database role SELECT permissions on the Department table.

What should you do next?

Create a trigger on the Department table that checks whether the database login of the user performing the insert or update operation belongs to a member of that department.

Include the WITH CHECK OPTION clause in the view definition.

Create a view that includes all columns in the Department table and the SQLLogin column from the Employees table.

Grant INSERT and UPDATE permissions on the Department table.

View Description

No description found.