sql 2008 permissiong issues

  • 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 ?

  • 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

  • Execute permissions denied. I am checking again with giving view definition permission on the database.

  • 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.

  • 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

  • Thanks All. I did not require execute permissions. However the problem resolved after granting VIE DEFINITION permission to the users.

  • 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.

  • 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