Sysadmins are pretty much powerful in the SQL Server environment. They can put the whole SQL Server infrastructure under their control. That said, it is important to know who else has this fixed server role.
There are situations where you need to grant SELECT permission to a particular user and limit that access to a particular OBJECT, say a TABLE.
SELECT
OBJECT
TABLE
Here’s a quick way of accomplishing this. In this example we’re using the AdventureWorks2008R2…