Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Contained database users Expand / Collapse
Author
Message
Posted Tuesday, April 5, 2011 6:37 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 8:01 PM
Points: 8,823, Visits: 9,381
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
Post #1088556
Posted Sunday, April 10, 2011 11:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
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
Posted Tuesday, September 20, 2011 3:42 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 4:01 PM
Points: 285, Visits: 56
Thats a nice feature... still work in CTP3?
Post #1178330
Posted Tuesday, September 20, 2011 7:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:51 AM
Points: 6,600, Visits: 8,900
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
Posted Wednesday, September 21, 2011 3:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 4:01 PM
Points: 285, Visits: 56
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 »

Add to briefcase ««12

Permissions Expand / Collapse