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 Saturday, April 2, 2011 12:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 7:58 AM
Points: 5,370, Visits: 9,010
Comments posted to this topic are about the item Contained database users

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 #1087818
Posted Saturday, April 2, 2011 12:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Nice question, thanks! It is good to provide exposure to some of the newer stuff coming up.
Post #1087819
Posted Sunday, April 3, 2011 10:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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

Before posting a performance problem please read
Post #1087857
Posted Sunday, April 3, 2011 9:47 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:36 PM
Points: 1,786, Visits: 1,116
Good question, learnt new feature of Denali today. Thanks
Post #1087898
Posted Monday, April 4, 2011 12:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Thanks for the question, I got to know of a new concept today.

Mohammed Moinudheen
Post #1087911
Posted Monday, April 4, 2011 8:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
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?
Post #1088068
Posted Monday, April 4, 2011 8:10 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 11:26 AM
Points: 668, Visits: 485
Nice question.
Post #1088077
Posted Monday, April 4, 2011 11:40 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
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
Post #1088198
Posted Tuesday, April 5, 2011 1:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 1:59 AM
Points: 1,042, Visits: 234
Thanks for the question. That was a learning for me.
Post #1088477
Posted Tuesday, April 5, 2011 3:43 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 11:57 AM
Points: 5,888, Visits: 13,062
has this feature been bought in just to make people used to oracle feel more at home?



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

Post #1088504
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse