The Case Of the Downward Pointing Arrow

Question

The Case Of the Downward Pointing Arrow

Viewing 12 posts - 16 through 27 (of 27 total)

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

Peter Schott SSCrazy Eights Points: 9676 More actions · Answer 1

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.

Gazareth One Orange Chip Points: 27737 More actions · Answer 2

Andy Warren (7/2/2014)
Definitely not enough clues here if you don't know Kendal

No S**t Sherlock! 😛

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

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

Anipaul SSC-Insane Points: 24681 More actions · Answer 4

Anipaul

SSC-Insane

Points: 24681

July 3, 2014 at 6:44 am

#1726774

Nice and interesting one.

Bangla Hall of Fame Points: 3137 More actions · Answer 5

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

Sean of the Lynchmob Ten Centuries Points: 1038 More actions · Answer 6

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

Andy Warren SSC Guru Points: 119902 More actions · Answer 7

Andy Warren

SSC Guru

Points: 119902

July 3, 2014 at 7:08 am

#1726795

Thanks Sean!

Andy
Connect with me on LinkedIn

RLilj33 SSCrazy Points: 2203 More actions · Answer 8

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!

Revenant SSC-Forever Points: 42467 More actions · Answer 9

I got this one right, but I admit, by sheer luck. Thanks, Andy!

Skanker Hall of Fame Points: 3059 More actions · Answer 10

loved the questions style....

...still got it wrong though...doh:hehe:

Andy Warren SSC Guru Points: 119902 More actions · Answer 11

I like any comment that includes tyranny:-)

Andy
Connect with me on LinkedIn

TomThomson SSC Guru Points: 104768 More actions · Answer 12

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