Use Data Control Language $($DCL$)$ statements that manage database user permissions.

Grant select, insert, and update permissions for Sales$-$related tables $($Orders & OrderDetails$)$ to the SalesPerson role.

Grant select and delete permissions for Sales$-$related tables to the SalesManager role.

Grant select permissions for the EmployeeDirectory view to the SalesPerson and SalesManager roles.

Grant select, insert, and update permissions for HR$-$related tables $($Employees & EmployeeTerritories$)$ to the HRperson role.

Grant select and delete permissions for HR$-$related tables to the HRmanager role.

Grant execute permission for the GiveEmployeeRaise stored procedure to the HRperson role