The Case Of the Downward Pointing Arrow

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

  • Andy Warren (7/2/2014)


    Definitely not enough clues here if you don't know Kendal

    No S**t Sherlock! 😛

  • 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

  • Nice and interesting one.

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

  • 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

  • Thanks Sean!

  • 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!

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

  • loved the questions style....

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

  • I like any comment that includes tyranny:-)

  • 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 12 posts - 16 through 27 (of 27 total)

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