Contained Database

What is contained database and how to create it is explained in earlier post Using Contained Database

Here is SQL query to list out contained database users who can connect to it. Any user like windows, group user or SQL Server user contained in database can connect to contained database

SELECT       
     principal_id     
    ,name
    ,type_desc
    ,authentication_type_desc 
FROM db_Contained.sys.database_principals 
WHERE authentication_type IN (2, 3)