Access Granted or Not?

Question

Access Granted or Not?

Andy Warren

SSC Guru

Points: 119902
More actions
June 2, 2014 at 11:04 pm

#308753

Comments posted to this topic are about the item Access Granted or Not?
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
June 3, 2014 at 7:14 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 19 total)

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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

Thank you Andy for a good question.

Quite certain I checked the right answer but still came as wrong. Either a bug or lack of industrial strength tanker sized espresso in the morning:-D

😎

Mighty SSCrazy Eights Points: 9063 More actions · Answer 2

Eirikur Eiriksson (6/2/2014)
lack of industrial strength tanker sized espresso in the morning:-D
😎

+1

Missed the "(select 2)".

Carlo Romagnano SSC-Insane Points: 22667 More actions · Answer 3

This feature will be removed in a future version of Microsoft SQL Server.

http://msdn.microsoft.com/en-us/library/ms174378%28v=sql.110%29.aspx

robertjtjones SSC-Addicted Points: 484 More actions · Answer 4

Cheers Andy - had to start off with all of them and eliminate one by one this time 🙂

free_mascot One Orange Chip Points: 27169 More actions · Answer 5

robertjtjones (6/3/2014)
Cheers Andy - had to start off with all of them and eliminate one by one this time 🙂

+1

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 6

Being sysadmin, I have worked with my own windows login authentication permissions and tried giving authentication off/on to a particular database, and got the answers correctly.

good question andy..

RLilj33 SSCrazy Points: 2153 More actions · Answer 7

Thanks Andy - well written QOTD with explanations.

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 8

and of course I read "This user is granted access to the database via a domain group" as the newbie had already checked the permissions of the group on the database. :unsure:

mickyT SSChampion Points: 10360 More actions · Answer 9

Mighty (6/3/2014)
Eirikur Eiriksson (6/2/2014)
lack of industrial strength tanker sized espresso in the morning:-D
😎
+1
Missed the "(select 2)".

+1 on the missed 1:-D

mickyT SSChampion Points: 10360 More actions · Answer 10

mickyT

SSChampion

Points: 10360

June 3, 2014 at 1:40 pm

#1718677

Also good question, thanks Andy

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

Yet another awesome question. Thanks Andy!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

rhythmk SSCertifiable Points: 7271 More actions · Answer 12

Nice question with nice explanation.Thanks Andy for question.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 13

Really interesting one..., thank you for the post, andy, now this a real-time qtod. 🙂

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.