January 8, 2010 at 6:53 am
I created a login with the following properties
public
db_datareader
db_datawriter
BUt still they say they cannot view the stored procedures when they login
Please help me
January 8, 2010 at 6:56 am
view the stored procedures or run them? they would also need exec permissions granted on the stored procedures to run them.
---------------------------------------------------------------------
January 8, 2010 at 7:06 am
View the stored procedures not execute
January 8, 2010 at 7:14 am
Grant VIEW DEFINITION on the procedures.
January 8, 2010 at 7:21 am
george sibbald (1/8/2010)
view the stored procedures or run them? they would also need exec permissions granted on the stored procedures to run them.
What george said is
GRANT VIEW DEFINITION ON [DBO].[proc_name] TO
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply