SQL Server Contained Database
A description of the feature including its benefits can be found here:
I would like it because it allows for managing users with password login at the database level instead of at the instance level. It is a feature that can be opted into on a per database basis once the capability is enabled for the instance. It would also mean I could develop locally and then deploy the database to your servers, including users.
My use case is having the ability to configure multiple users that can login with different permissions. A read only user, for example, or a user with unlimited rights to a specific schema while having only read only access to the rest of the database.
![](https://secure.gravatar.com/avatar/2b691806f42e351ccd9f0505b5f41719?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)