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
