sqlfriends (3/13/2013)...when granting execute on schema, what does execute mean?
execute stored procedures,
how about functions and triggers etc?
Thanks
EXECUTE privilege is for stored procedures and scalar functions
SELECT privilege would be for tables, views, and table valued functions
triggers are events that happen behind the scenes and don't have permissions on them