Home Dashboard Directory Help

Contained database logins should be able to access other databases by Nizamettin Özpolat


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Suggestion
ID: 781656
Opened: 3/19/2013 3:54:58 AM
Access Restriction: Public


Contained database feature is a good feature. But some functionalities should be added. Let's say we have a login and this login accesses more then one database. It is not possible to make this login contained for the time being. Because whenever this login becomes contained, will not be able to access the other databases.
Most applications do not access just one database. To be able to make this contained login useful, contained login should be able to access other databases.
Sign in to post a comment.
Posted by Microsoft on 4/12/2013 at 2:25 PM
After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.

Thanks again for providing the product suggestion and continued support for our product.

Umachandar, SQL Programmability Team
Posted by Nizamettin Özpolat on 3/20/2013 at 1:56 AM
Thanks for your workaround Robert, but your recommend has security concerns and I am not sure whether microsoft supports this workaround.
Posted by Robert L Davis on 3/19/2013 at 11:28 AM
You already can. See my reply under workarounds.
Posted by AaronBertrand on 3/19/2013 at 10:40 AM
I think you may be confused about the purpose of contained databases.
Sign in to post a workaround.
Posted by Robert L Davis on 3/19/2013 at 11:28 AM
You already can. I blogged about how to do this already: http://www.sqlsoldier.com/wp/sqlserver/crossdatabasequeriesbycontainedusers