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?
No description found.