The Unusable User

Question

The Unusable User

Andy Warren

SSC Guru

Points: 119902
More actions
March 25, 2014 at 8:56 pm

#151333

Comments posted to this topic are about the item The Unusable User
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
March 26, 2014 at 2:21 am

This was removed by the editor as SPAM

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

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

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

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: 259115 More actions · Answer 2

Great question, thanks.

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

paul.knibbs SSCoach Points: 15320 More actions · Answer 3

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 More actions · Answer 4

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: 104210 More actions · Answer 5

3 easy points blown.

must.read.question.carefully.

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

Neil Burton SSC-Insane Points: 23009 More actions · Answer 6

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: 11368 More actions · Answer 7

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 More actions · Answer 8

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 More actions · Answer 9

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

WayneS SSC Guru Points: 95460 More actions · Answer 10

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: 281334 More actions · Answer 11

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: 119902 More actions · Answer 12

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

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

timwell SSCertifiable Points: 5315 More actions · Answer 13

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.