Grant execute on sql user

Back in the early days of sql server, stored procedures were much faster compared to normal queries. This meant that a typical system would host more than 200 stored procedures (hopefully on the same schema). In order to grant execute access to a role or user you can use the following snippet

	GRANT EXECUTE ON DATABASE::DatabaseName TO SomeRoleOrUser;
	GRANT EXECUTE ON SCHEMA::dbo TO SomeRoleOrUser;

view raw GrantExecute hosted with ❤ by GitHub