Alter User

Question

Alter User

okbangas

SSChampion

Points: 11773
More actions
February 16, 2013 at 12:54 pm

#270978

Comments posted to this topic are about the item Alter User

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter
Concatenating Row Values in Transact-SQL[/url]

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

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

TomThomson SSC Guru Points: 104768 More actions · Answer 1

Nice straightforward question. I had to do some reading because I didn't know teh answer, but for me that makes it a good question.

But I wonder why this strange restriction that alter user can't provide a login for a user who doesn't already have one exists. Presumably MS has some reason for it, but BoL just tells us about the restriction and doesn't give any reason for it (tha's fairly standard for BoL, of course).

Tom

mickyT SSChampion Points: 10360 More actions · Answer 2

mickyT

SSChampion

Points: 10360

February 17, 2013 at 11:10 am

#1588682

Nice question thanks.

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Nice question to start with on Monday Morning. Got to learn something, I was not aware of. Thanks:-)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 4

Nice question with having good basic information.

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

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

Interesting question, thanks.

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

demonfox SSCertifiable Points: 6289 More actions · Answer 6

Koen Verbeeck (2/18/2013)
Interesting question, thanks.

+1

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 7

Iulian -207023

SSCertifiable

Points: 7639

February 18, 2013 at 2:01 am

#1588742

Nice one, thanks

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

Interesting question, thank you for posting.

Did not tried this before, so had really no idea , but bit search on offline BOL, was able to guess that opt-3 may be the answer.

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

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 9

Raghavendra Mudugal (2/18/2013)
Did not tried this before, so had really no idea , but bit search on offline BOL, was able to guess that opt-3 may be the answer.

+1

--
Dineshbabu
Desire to learn new things..

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 10

If somebody explains step by step on actually what happening will be very helpful..

--
Dineshbabu
Desire to learn new things..

sestell1 SSChampion Points: 10230 More actions · Answer 11

Wow, interesting... and very odd.

I'd be curious to know the reason behind this restriction.

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

Revenant

SSC-Forever

Points: 42467

February 18, 2013 at 10:18 am

#1588912

Really good one -- thanks!

Venkat Jonnalagadda Mr or Mrs. 500 Points: 510 More actions · Answer 13

Got this one right after a lot of reading.. Thanks for a good qotd..

___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 14

+1, I'm rather curious about that restriction and didn't find anything enlightening in BOL, which states:

The WITH LOGIN clause enables the remapping of a user to a different login. Users without a login, users mapped to a certificate, or users mapped to an asymmetric key cannot be re-mapped with this clause. Only SQL users and Windows users (or groups) can be remapped. The WITH LOGIN clause cannot be used to change the type of user, such as changing a Windows account to a SQL Server login.

The name of the user will be automatically renamed to the login name if the following conditions are true.

Does that mean that, should we end up with a user that is not mapped to any logins, the only recourse is to drop that user and recreate it as mapped?

Andre Ranieri