Database objects view rights to user | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database objects view rights to user

Hi all I was looking for only datbaase objects view rights to database user but no luck.. I want to give only view rights on all the user objects to the users… Thanks in advance.
Refer to the BOL for DB_DATAREADER fixed database role. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
aware of this satya.. but user cannot view code of SP or table design..any other way? Thanks…
Try granting VIEW DEFINITION to user…
Check BOL for details.. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
I just gave you a link to refer, there under the reference you will find the reply for this.
Also look at the GRANT statement in BOL.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>