InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:43:33 GMT20http://www.sqlservercentral.com/Forums/Topic1071818-1526-1.aspxIf you want to restrict user can see only definition of the objects then remove all rights exclude public then give VIEW DEFINITIONRegards,Syed Jahanzaib Bin HassanMCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBAMy Blog www.aureus-salah.comTue, 26 Apr 2011 05:37:50 GMTSyed Jahanzaib Bin hassanhttp://www.sqlservercentral.com/Forums/Topic1071818-1526-1.aspxIs he a member of db_datareader? A member of db_owner? a member of sysadmin?Granting view definition doesn't remove permissions, it adds permissionsWed, 13 Apr 2011 05:58:38 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1071818-1526-1.aspxI am not able to restrict user.He still able to see all the data.Wed, 13 Apr 2011 04:43:42 GMTsherwincurthttp://www.sqlservercentral.com/Forums/Topic1071818-1526-1.aspx[code="sql"]GRANT VIEW DEFINITION[/code]Check this link:[url=http://msdn.microsoft.com/en-us/library/ms175808.aspx][/url]Tue, 12 Apr 2011 19:13:40 GMTYsaias Portes-QUI Grouphttp://www.sqlservercentral.com/Forums/Topic1071818-1526-1.aspxI find Google quite useful when I can't remember the syntax of a command: http://www.mssqltips.com/tip.asp?tip=1593Wed, 02 Mar 2011 04:51:55 GMTDwayne Dibleyhttp://www.sqlservercentral.com/Forums/Topic1071818-1526-1.aspxHi all,how to give the permissions to user for view definition of Object in sql server 2008 r2Thanks to allWed, 02 Mar 2011 04:18:08 GMTgeetha@in