Post reply

Contained database users

  • April 2, 2011 at 12:26 pm

    #248961

    Comments posted to this topic are about the item Contained database users

    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

  • April 2, 2011 at 12:28 pm

    #1306785

    Nice question, thanks! It is good to provide exposure to some of the newer stuff coming up.

  • April 3, 2011 at 10:11 am

    #1306815

    Nice question.

    And what the QOD is all about. Testing what you do know and / or teaching you new things you did not know.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • April 3, 2011 at 9:47 pm

    #1306846

    Good question, learnt new feature of Denali today. Thanks

  • April 4, 2011 at 12:09 am

    #1306857

    Thanks for the question, I got to know of a new concept today.

    M&M

  • April 4, 2011 at 8:04 am

    #1306987

    Nice question.

    I had heard about this feature request for SQL Server Logins and DB Users being seperated back when 2005 was a Beta.

    I wonder if there is any current information on the following questions:

    *How does a High Volume Transactional (at least over 200 batches per minute with 100 updates and 50 inserts per minute) database perform when the users accounts are all Contained? Does that change with

    * How does the security context switching work to limit user access in the contained DB with contained users vs users with SQL Logins?

    * Will a SQL Login automaticly win a resource lock conflict with a contained user?

  • April 4, 2011 at 8:10 am

    #1306996

    Nice question.

  • April 4, 2011 at 11:40 am

    #1307095

    Nice Question Wayne - thanks.

    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

  • April 5, 2011 at 1:57 am

    #1307331

    Thanks for the question. That was a learning for me.:-)

  • April 5, 2011 at 3:43 am

    #1307353

    has this feature been bought in just to make people used to oracle feel more at home?

    🙂

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

  • April 5, 2011 at 6:37 am

    #1307400

    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

  • April 10, 2011 at 11:39 pm

    #1309662

    Nice question, thanks.

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

  • September 20, 2011 at 3:42 pm

    #1384226

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

  • September 20, 2011 at 7:49 pm

    #1384289

    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
    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

  • September 21, 2011 at 3:45 pm

    #1384867

    Yhea... im downloaded and instaled... now reading documentation.

    http://msdn.microsoft.com/en-us/library/ff929071(v=SQL.110).aspx

    i think in isolation my users.

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

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