Contained database users

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » Contained database users

15 posts, Page 2 of 2

««1 2

Contained database users

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Tuesday, April 05, 2011 6:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143

Nice question.

I couldn't remember what the configuration setting that allows contained users is called, so at first dithered but then I recalled that it has to be set to allow contained users to be created; that meant that having an account in the contained DB implied the setting was already done so I picked the have an account answer and got the point.

Esoteric stuff for me, this; I read up a bit on denali last year but have never used it, not even played with it. The contained domain user concept worries me, either as a potential insecurity or as a big hole in containment because I don't understand what happens when the domain user ceases to exist in the domain (or the database is moved to an instance in a different domain). Maybe we will see a QoTD on that some time?

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1088556

Koen Verbeeck

Posted Sunday, April 10, 2011 11:39 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

Nice question, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1091245

froldan

Posted Tuesday, September 20, 2011 3:42 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, September 10, 2012 12:25 PM
Points: 285, Visits: 41

Thats a nice feature... still work in CTP3?

Post #1178330

WayneS

Posted Tuesday, September 20, 2011 7:49 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:38 PM
Points: 6,368, Visits: 8,230

froldan (9/20/2011)

Thats a nice feature... still work in CTP3?

Yep, it sure does! Are you going to download it and play with it?

Wayne
Microsoft Certified Master: SQL Server 2008

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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #1178397

froldan

Posted Wednesday, September 21, 2011 3:45 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, September 10, 2012 12:25 PM
Points: 285, Visits: 41

Yhea... im downloaded and instaled... now reading documentation.
http://msdn.microsoft.com/en-us/library/ff929071(v=SQL.110).aspx
[url=http://msdn.microsoft.com/en-us/library/ff929071(v=SQL.110).aspx][/url]

i think in isolation my users.

Post #1179075

« Prev Topic | Next Topic »

15 posts, Page 2 of 2

««1 2

Permissions