• 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