October 14, 2011 at 5:28 am
i have set up new sql 2008 database server. I have created windows group Win_Read and provided it db_datareader and VIEW DEFINITION ON DATABASE DB_Test. Still the users inside the group are not able to see the stored procedures in object explorer and also not able to do the sp_helptext. How can I provide them read access in a way that they can check the definition of stored procedures and also able to see them in object explorer ?
October 17, 2011 at 1:27 am
sqlnaive (10/14/2011)
i have set up new sql 2008 database server. I have created windows group Win_Read and provided it db_datareader and VIEW DEFINITION ON DATABASE DB_Test. Still the users inside the group are not able to see the stored procedures in object explorer and also not able to do the sp_helptext. How can I provide them read access in a way that they can check the definition of stored procedures and also able to see them in object explorer ?
What error do they get when they use sp_helptext ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
October 17, 2011 at 3:49 am
Execute permissions denied. I am checking again with giving view definition permission on the database.
October 17, 2011 at 4:07 am
Execute permissions denied. I am checking again with giving view definition permission on the database.
Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database. It doesn't include EXECUTE permission in it.
October 17, 2011 at 5:38 am
sqlnaive (10/17/2011)
Execute permissions denied. I am checking again with giving view definition permission on the database.
Run this and try
Grant Execute to Win_Read
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
October 18, 2011 at 1:35 am
Thanks All. I did not require execute permissions. However the problem resolved after granting VIE DEFINITION permission to the users.
October 18, 2011 at 1:48 am
I did not require execute permissions. However the problem resolved after granting VIE DEFINITION permission to the users.
I assumed you already granted that. The same is mentioned in your previous post.
I have created windows group Win_Read and provided it db_datareader and VIEW DEFINITION ON DATABASE DB_Test. Still the users inside the group are not able to see the stored procedures in object explorer and also not able to do the sp_helptext.
October 18, 2011 at 9:57 am
Yeah. I think it should be some manual error else it would have not occured in first place.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy