Post reply

sql server permissions

  • January 4, 2012 at 10:31 am

    #262360

    I am new to setting up rights for users in a sql server 2008 r2 standard edition database. I am a programmer in a small company that just told me to do the dba work.

    Thus my question is I have a user that 'execute reader' and 'execute writer' permissions. The user can only see system tables and system stored proecuedres. They can not use the user tables and user stored procedures. Thus can you tell me what additional access level I need to setup for them? Do they need ddladmin rights?

  • January 24, 2012 at 11:51 am

    #1437875

    You could use the builtin database role db_datareader to grant access to see all the tables. I suspect this post should not be part of the Report Server 2008 Administration.

    Francis

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply