How to List all Contained Users in a SQL Server Contained Database

Contained Databases feature is introduced in SQL Server 2012.

User authentication for contained users (users with passwords) is performed by the contained database.

To list all contained users that are authenticated by the contained database, use the following query:

USE Database_Name
GO
SELECT name, type_desc, authentication_type, authentication_type_desc
FROM sys.database_principals WHERE authentication_type = 2
GO

contained_user_list