This statement gives Mary and the “sales” group permission to insert into and delete from the titles table:
grant insert, delete on titles to mary, sales
This statement gives Harold permission to use the stored procedure makelist:
grant execute on makelist to harold
This statement grants permission to execute the custom stored procedure sa_only_proc to users who have been granted the system administrator role:
grant execute on sa_only_proc to sa_role
This statement gives Aubrey permission to select, update, and delete from the authors table and to grant the same permissions to other users:
grant select, update, delete on authors to aubrey with grant option
This statement grants permission to the payroll employees to update salaries during December:
grant update (salary) on employee where date_part(month, getdate()) = 12 to payroll_role