GRANT Object Permissions

GRANT SELECT ON OBJECT::Person.Address TO RosaQdM --Granting SELECT permission on a table

GRANT EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo TO Recruiting11 --Granting EXECUTE permission on a stored procedure

GRANT REFERENCES (BusinessEntityID) ON OBJECT::HumanResources.vEmployee TO Wanida WITH GRANT OPTION --Granting REFERENCES permission on a view with GRANT OPTION

GRANT SELECT ON Person.Address TO RosaQdM --Granting SELECT permission on a table without using the OBJECT phrase

GRANT SELECT ON Person.Address TO [AdventureWorks2008R2\RosaQdM] --Granting SELECT permission on a table to a domain account

GRANT EXECUTE ON dbo.uspGetBillOfMaterials TO newrole ; --Granting EXECUTE permission on a procedure to a role

Details in:

http://msdn.microsoft.com/en-us/library/ms188371.aspx