i have given a user with datareader/datawriter/execute permission on a database. still then user is able to see procedure as locked icon and more over can't run sp_helptext.. what is issue here what more permission or things i can do for that user.. looks issue is with something else.. help..!
asked Nov 03 '11 at 10:13 PM in Default
For a user to see the definition of user objects, it must have any one of the following permissions: ALTER, CONTROL, TAKE OWNERSHIP, or VIEW DEFINITION. I guess in your case you should give VIEW DEFINITION permission. Cheers.
answered Nov 03 '11 at 11:34 PM
to use a sp_helptext on an object you need to hvae ALTER, CONTROL, TAKE OWNERSHIP, or VIEW DEFINITION permission on that object.
So if you have only datareader/datawriter/execute permission, than you will not be able to view the definition of the object.
The lock icon could also signal, that the object is encrypted. For such encrypted objects you will not eb able to view the definition even you have the above mentioned permissions.
answered Nov 03 '11 at 11:44 PM