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