Tag Archives: Granting View Definition Permission to a User or Role in SQL Server

How to Give Read Definition Permission to a User for all Procedures and Functions

One of the developer complaint that he is getting a following error message while issuing sp_help, sp_helptext or using the object_definition() function to view the definition of object EXEC sp_help Sales Msg 15009, Level 16, State 1, Procedure sp_help, Line 66 The object ‘Sales’ does not exist in database ‘TEST’ or is invalid for this [...]