July 2, 2014 at 1:04 pm
A winner! Yes, the poor DBA is Kendal Van Dyke, who leads MagicPASS in Orlando.
July 2, 2014 at 2:33 pm
I ended up knowing this mostly because we use custom permissions w/ SSDT (to handle multiple environments and based on Jamie Thomson's work). Without including the "GRANT CONNECT" statement, we get those wonderful arrows. I'd left them out for a while and caught it when publishing our changes resulted in no access to the affected databases. Many edits later, we were good to go again after each publish operation. Of course before that I assumed login/user mismatch or some similar root cause, but a simple GRANT CONNECT fixed all and was much easier to implement.
July 3, 2014 at 4:18 am
Andy Warren (7/2/2014)
Definitely not enough clues here if you don't know Kendal
No S**t Sherlock! 😛
July 3, 2014 at 6:10 am
Very interesting question.
Sherlock may return 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 3, 2014 at 6:44 am
Nice and interesting one.
July 3, 2014 at 6:47 am
crussell-931424 (7/3/2014)
Andy, I just read through the complete explanation you gave with this question. The historic background about your friend was very interesting.
Agree......
July 3, 2014 at 6:59 am
Thanks Andy, good question to get the grey matter thinking about security. Personally I really liked the format of the question, it was a great way to add interest so do it again!
Sean
July 3, 2014 at 7:08 am
July 3, 2014 at 7:17 am
My 2 cents is that I enjoyed the format of the question. Shows the creative touch that so often has to be suppressed in the tyranny of the urgent!
July 3, 2014 at 4:29 pm
I got this one right, but I admit, by sheer luck. Thanks, Andy!
July 9, 2014 at 1:48 am
loved the questions style....
...still got it wrong though...doh:hehe:
July 9, 2014 at 6:59 am
I like any comment that includes tyranny:-)
July 15, 2014 at 9:13 pm
Interesting.
When I deny connect permission to a login and then refresh the view in ssms I get no little red arrows. Maybe it only happens for users to which SQL logins are mapped, and not for users to whech windows logins are mapped? Seems very strange.
Tom
Viewing 13 posts - 16 through 27 (of 27 total)
You must be logged in to reply to this topic. Login to reply