• bmanning 59285 (6/27/2012)


    Hi

    I am a newbie, I need to give an access to all tables and stored procedures in the database with

    select and view permissions only on SQL server 2008 R2. I want to also restrict the user to have access only to the tables and the stored procedures or views.

    If so please advise how to do so.

    Thanks a lot in advance.

    Brian

    The first question I have is why do you want to give view and read permissions to all tables and view permissions to all procs? If we're talking about a production database that would violate the idea that one should have permissions to do their job, no more, no less. In some cases that does indeed mean giving perms to all objects as you mentioned (e.g. a prod support role) but usually that is not the case.

    PS I see you are a new member on the site. Welcome to SSC. For future reference it's polite to start a new thread for new questions, instead of hijacking someone else's thread. Feel free to start a new thread and post the link here.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato