The Unusable User

  • Andy Warren

    SSC Guru

    Points: 119676

    Comments posted to this topic are about the item The Unusable User

  • free_mascot

    One Orange Chip

    Points: 27168

    Indeed a good question Andy, Thank you.

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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Great question, thanks.

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

  • This was removed by the editor as SPAM

  • paul.knibbs

    SSCoach

    Points: 15270

    One of those where I had no clue as to the answer so picked a random one to see what the real answer was--therefore I learned something today, which is always good! πŸ™‚

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Good one Andy, Very very different one.. πŸ™‚

    (I got the answer wrong, what I did is created the user (one query) and just mapped to the database (another query), but in both no role was set. I then logged in as this new user and tried to query the table and it gave permission error and then I executed another query in the admin window for adding role, when I disconnected and connected with new user and checked the output was seen. So I thought of the orphaned option thinking might be role has not been associated.)

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

  • george sibbald

    SSC Guru

    Points: 104200

    3 easy points blown.

    must.read.question.carefully.

    ---------------------------------------------------------------------

  • Neil Burton

    SSC-Insane

    Points: 22128

    It's possible that he is in the wrong context, but we'll assume based on the intro that he is in the correct place.

    I'm admittedly a bit of a newbie and certainly a BI developer rather than a DBA, so I accept that I'm going to get a lot of the questions wrong. However, when an explanation starts with 'we'll assume' I feel a bit cheated. I know that assuming something is a certain way is a surefire way to waste a lot of time. I'm sure that everybody has had a conversation along the lines of:

    You/them, 'have you checked..?',

    You/them, 'it's definitely .....',

    You/them, 'yeah, but have you checked it?

    You/them, 'oh'

    Don't get me wrong, I learn something every time, I just feel that answers that make assumptions can stack the deck against getting the answer right, particularly when the assumption can rule in\out a valid answer.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    β€”Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • Toreador

    SSChampion

    Points: 11248

    It's possible that he is in the wrong context, but we'll assume based on the intro that he is in the correct place.

    Nope, based on the preamble

    first confirming the login exists on the instance and then finding that it does not exist in the database used by the application

    it's clear that although he's in the right context, he's checked the wrong database by mistake.

    πŸ˜‰

  • sestell1

    SSChampion

    Points: 10230

    Toreador (3/26/2014)


    It's possible that he is in the wrong context, but we'll assume based on the intro that he is in the correct place.

    Nope, based on the preamble

    first confirming the login exists on the instance and then finding that it does not exist in the database used by the application

    it's clear that although he's in the right context, he's checked the wrong database by mistake.

    πŸ˜‰

    I agree, being in the wrong database seemed like a much more likely scenario to me.

    Especially since there was no use statement preceding the command.

    Had the command included a use statement for the appropriate database, then I would have assumed the more obscure answer since there was no mention of a database restore.

  • ssimmons 2102

    SSCommitted

    Points: 1634

    Since there was no Use statement, being in the wrong database seem to be the most likey answer to me.

  • WayneS

    SSC Guru

    Points: 95362

    Great question Andy

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks Andy. I enjoy this style of questions you have been doing.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Andy Warren

    SSC Guru

    Points: 119676

    Jason, thanks for that. I'm experimenting a little, trying to see what works.

  • timwell

    SSCertifiable

    Points: 5014

    I have a suggestion: You say:

    Theodore saw the error message, made a change, and went back to answering the QOTD.

    I think you might have made the description more clear if it said:

    Theodore saw the error message, made a change to the script, ran it again, and went back to answering the QOTD.

    (I made the wrong guess based on that ambiguity)

    Thanks for the QOD. I learned something as usual.

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

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