Preventing a SELECT

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715401

    Comments posted to this topic are about the item Preventing a SELECT

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71362

    Nice, easy one to start the week on, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • leddybill

    SSC Enthusiast

    Points: 190

    "other people will want access".  Could you be a little more specific as to whether you intend to provide access to those people?

  • Jeff Moden

    SSC Guru

    Points: 994555

    leddybill wrote:

    "other people will want access".  Could you be a little more specific as to whether you intend to provide access to those people?

    It doesn't actually matter.  Whether that possibility is realized or not, there's really only one right way to do this from the list of possible answers.

     

    There IS an even more secure method but is well beyond the requirements of this question.

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715401

    This isn't an actual situation, but a contrived one. I have had similar situations, but in this case, the statement is intended to shape the question so you can answer it. Granting others access would be a future request, so the idea here is for you to consider that as a requirement. Intention is not necessary; planning is.

  • Jeff Moden

    SSC Guru

    Points: 994555

    Stewart "Arturius" Campbell wrote:

    Nice, easy one to start the week on, thanks Steve

    At the time of this post, I see that 18% (a whopping 42 out of 230) of the folks that answered got it wrong.  Apparently, it's not so simple for some.  It's no wonder that you end up reading about so many penetrations in the news.

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71362

    Jeff Moden wrote:

    Stewart "Arturius" Campbell wrote:

    Nice, easy one to start the week on, thanks Steve

    At the time of this post, I see that 18% (a whopping 42 out of 230) of the folks that answered got it wrong.  Apparently, it's not so simple for some.  It's no wonder that you end up reading about so many penetrations in the news.

     

    very true...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • srienstr

    SSCrazy

    Points: 2246

    Jeff Moden wrote:

    There IS an even more secure method but is well beyond the requirements of this question.

    Create a view with the columns or where criteria that you intend to provide and grant select on that view?


    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

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

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