SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / Checking database access / Latest Posts

RE: Checking database access

BudaCli — Thu, 02 Aug 2012 08:25:01 GMT

3rd option almost tricked me

RE: Checking database access

Robin Sasson — Thu, 24 May 2012 06:02:57 GMT

Good question thanks

RE: Checking database access

Koen Verbeeck — Tue, 24 Jan 2012 02:41:41 GMT

Great question, thanks.

RE: Checking database access

Britt Cluff — Mon, 16 Jan 2012 05:22:18 GMT

Nice question Steve, thanks.

RE: Checking database access

DBA_Dom — Thu, 12 Jan 2012 10:23:01 GMT

Nice, tried to get a little tricky with that third option. Good question.

RE: Checking database access

rfr.ferrari — Thu, 12 Jan 2012 05:32:21 GMT

Good question!!!Thanks Steve!!!!!

RE: Checking database access

george sibbald — Wed, 11 Jan 2012 10:46:39 GMT

good question I think. Reminds people of the function (or brings it to their attention for the first time) so its educational, but steve put a little twist in it so you had to think and not just google it.

RE: Checking database access

BarbW — Wed, 11 Jan 2012 10:37:41 GMT

ARRGH! should read the WHOLE question and choose two! :w00t:

RE: Checking database access

OzYbOi d(-_-)b — Wed, 11 Jan 2012 09:14:23 GMT

tks for the question

RE: Checking database access

Revenant — Wed, 11 Jan 2012 08:52:47 GMT

Got this one wrong, but learned something...Thanks, Steve!

RE: Checking database access

codebyo — Wed, 11 Jan 2012 08:18:32 GMT

[quote][b]SQL Kiwi (1/11/2012)[/b][hr]This function is one I don't use much. I know what it does, but I hovered between single-user and suspect as the second option to the obvious first correct answer. I have no experience of executing HAS_DBACCESS against a single-user mode database or a suspect one, so I took a guess.[/quote]That's exactly what was on my mind and exactly the same answers I marked.Best regards,

RE: Checking database access

jeff.mason — Wed, 11 Jan 2012 07:36:58 GMT

[quote][b]SQL Kiwi (1/11/2012)[/b][hr][quote][b]L' Eomot Inversé (1/11/2012)[/b][hr]Nice and simple.[/quote]I see a lot of people saying this, but either my product knowledge is significantly below average or we're doing something differently. I don't, for example, check BOL before answering - I do it on the spot. That's not to say either way is right or wrong, just a potential point of difference.[quote]I'm very surprised there's only 34% correct so far, although I would expect the wiggle on whether no other user is connected to a db which is in single-user mode would catch a few who didn't think hard (it returns 1 if an attempt to connect would have succeeded, which makes it pretty obvous that it can't return 1 if someone else is connected in single user mode, but while Vulcans might always get something like that right us poor humans sometimes don't think hard enough), but that doesn't seem to account for enough of the wrong answers.[/quote]This function is one I don't use much. I know what it does, but I hovered between single-user and suspect as the second option to the obvious first correct answer. I have no experience of executing HAS_DBACCESS against a single-user mode database or a suspect one, so I took a guess.edit: I should add that I am unsure of the value of this question, beyond one that simply asked a 'nice and simple' question about what HAS_DBACCESS does in normal circumstances. I don't expect to remember the second correct option for any length or time, or that it would ever be important for me to do so. Overall: meh.[/quote]I agree on the "not so obvious". I also didn't use BOL but reasoned it like this -- you can't USE a DB when it is suspect and most of the time you have to USE a DB to run a function against it, so since you can't use a suspect DB you can't run this function against it. Obviously based upon the answer you must be able to run it against any DB regardless of connection context.

RE: Checking database access

Paul White — Wed, 11 Jan 2012 06:55:52 GMT

[quote][b]L' Eomot Inversé (1/11/2012)[/b][hr]Nice and simple.[/quote]I see a lot of people saying this, but either my product knowledge is significantly below average or we're doing something differently. I don't, for example, check BOL before answering - I do it on the spot. That's not to say either way is right or wrong, just a potential point of difference.[quote]I'm very surprised there's only 34% correct so far, although I would expect the wiggle on whether no other user is connected to a db which is in single-user mode would catch a few who didn't think hard (it returns 1 if an attempt to connect would have succeeded, which makes it pretty obvous that it can't return 1 if someone else is connected in single user mode, but while Vulcans might always get something like that right us poor humans sometimes don't think hard enough), but that doesn't seem to account for enough of the wrong answers.[/quote]This function is one I don't use much. I know what it does, but I hovered between single-user and suspect as the second option to the obvious first correct answer. I have no experience of executing HAS_DBACCESS against a single-user mode database or a suspect one, so I took a guess.edit: I should add that I am unsure of the value of this question, beyond one that simply asked a 'nice and simple' question about what HAS_DBACCESS does in normal circumstances. I don't expect to remember the second correct option for any length or time, or that it would ever be important for me to do so. Overall: meh.

RE: Checking database access

mtassin — Wed, 11 Jan 2012 06:53:44 GMT

[quote][b]L' Eomot Inversé (1/11/2012)[/b][hr]Nice and simple.I'm very surprised there's only 34% correct so far, although I would expect the wiggle on whether no other user is connected to a db which is in single-user mode would catch a few who didn't think hard (it returns 1 if an attempt to connect would have succeeded, which makes it pretty obvous that it can't return 1 if someone else is connected in single user mode, but while Vulcans might always get something like that right us poor humans sometimes don't think hard enough), but that doesn't seem to account for enough of the wrong answers.[/quote]I got it wrong, because instead of BOL, I just used SSMS's SQL Help (2008 R2). For that I have[quote]RemarksHAS_DBACCESS returns 1 if the user has access to the database, 0 if the user has no access to the database, and NULL if the database name is not valid.[/quote]

RE: Checking database access

bitbucket-25253 — Wed, 11 Jan 2012 06:20:54 GMT

Still a suprisingly low correct[center][b]Correct answers: 35% (100) Incorrect answers: 65% (183) Total attempts: 283 [/b][/center]

RE: Checking database access

Thomas Abraham — Wed, 11 Jan 2012 05:32:16 GMT

Is it Monday? Thanks for an easy one.

RE: Checking database access

L' Eomot Inversé — Wed, 11 Jan 2012 04:05:38 GMT

Nice and simple.I'm very surprised there's only 34% correct so far, although I would expect the wiggle on whether no other user is connected to a db which is in single-user mode would catch a few who didn't think hard (it returns 1 if an attempt to connect would have succeeded, which makes it pretty obvous that it can't return 1 if someone else is connected in single user mode, but while Vulcans might always get something like that right us poor humans sometimes don't think hard enough), but that doesn't seem to account for enough of the wrong answers.

RE: Checking database access

paul s-306273 — Wed, 11 Jan 2012 03:10:53 GMT

Nice question Steve.Who's surprised that only 34% corrcet so far?

RE: Checking database access

Carlo Romagnano — Wed, 11 Jan 2012 02:54:56 GMT

I like qotd about new and/or particular feature.Thanks!:-D

RE: Checking database access

440692 I am just a number — Wed, 11 Jan 2012 01:27:18 GMT

AGGGH!I missed the obvious, checked BOL, selected my option (singular) submitted.Good question. ThanksIan

RE: Checking database access

Stewart "Arturius" Campbell — Wed, 11 Jan 2012 01:21:55 GMT

That'll teach me to attempt these questions before my first cup of coffee in the morning.:hehe:good question, thanks.

RE: Checking database access

mohammed moinudheen — Wed, 11 Jan 2012 00:49:46 GMT

Good question Steve.

RE: Checking database access

SQLRNNR — Tue, 10 Jan 2012 20:51:33 GMT

Nice - keep em coming.

RE: Checking database access

bitbucket-25253 — Tue, 10 Jan 2012 20:50:40 GMT

Another nice easy question ......... Thanks

Checking database access

Steve Jones - SSC Editor — Tue, 10 Jan 2012 20:49:52 GMT

Comments posted to this topic are about the item [B]Checking database access[/B]