Grant Database Objects to User Role

Grant Stored Procedure to Role

GRANT EXECUTE ON dbo.uspMySP TO MyRole;

Grant Function to Role

GRANT SELECT ON dbo.fnMyFunction TO MyRole;

Grant Type to Role

GRANT REFERENCES, EXECUTE ON TYPE::dbo.tyMyType TO MyRole;

Grant Table to Role

GRANT INSERT, SELECT, UPDATE, DELETE ON dbo.tbMyTable TO MyRole;

Grant View to Role

GRANT SELECT ON dbo.vMyView TO MyRole;