Read Only Access for Query designer?

  • The SQL Server Query Designer is a great visual tool.  My team wants to give a user read only access to it.
    If I give read access to a database, the designer is grayed out,  If I give ddladmin permissions they can change the query in the designer.
    Is there a painless way to do this?

    thanks.

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

  • fizzleme - Thursday, March 29, 2018 12:17 PM

    The SQL Server Query Designer is a great visual tool.  My team wants to give a user read only access to it.
    If I give read access to a database, the designer is grayed out,  If I give ddladmin permissions they can change the query in the designer.
    Is there a painless way to do this?

    thanks.

    View definition and db_datareader would be another option. You'd need to look over that permission and see if that's okay for the user, your company. You can apply view definiton at the database level, schema level or individual objects.

    Sue

  • This is correct.  I used View Definition with the database option.

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

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

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