Preventing a SELECT

Question

Preventing a SELECT

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
May 13, 2019 at 12:00 am

#3525216

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

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

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

Stewart "Arturius" Campbell SSC Guru Points: 72498 More actions · Answer 1

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”

Bill SSC Enthusiast Points: 194 More actions · Answer 2

"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: 1003863 More actions · Answer 3

Bill 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.

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)

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 4

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: 1003863 More actions · Answer 5

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.

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)

Stewart "Arturius" Campbell SSC Guru Points: 72498 More actions · Answer 6

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: 2435 More actions · Answer 7

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.