Post reply

View read only acess

  • June 13, 2014 at 8:21 am

    #292349

    Hi,

    I have 10 views in our Develoment DB server

    How to provide only 2 View and read only Access for the login & users

  • June 13, 2014 at 5:15 pm

    #1721685

    jamessdba (6/13/2014)

    Hi,

    I have 10 views in our Develoment DB server

    How to provide only 2 View and read only Access for the login & users

    GRANT.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 17, 2014 at 2:00 am

    #1722174

    Hi,

    Could you please provide full Query(only for 2 views)

    ex: i have 10 views names (A,B,C,D,E,F,G,H,I,J)

    i have to gives view access to only (E,& F) to one login/user.

    Thanks in advance

  • June 17, 2014 at 3:12 am

    #1722195

    If you read this article it should point you in the right direction. It will be almost impossible to write the exact query you need from the information you've provided.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

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

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