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