FROM master.sys.database_principals;
System sys.database_principals includes the following columns:
COLLECTION NOTE User name created in the CREATE USER principal_id command principal code (numeric value) typeType principal:
S = User of SQL Server
U = User of Windows
G = Windows group
A = Application role
R = Database role
C = Certificate has mapped
K = Asymmetric key is mapped
Description of principal types:
SQL_USER
WINDOWS_USER
WINDOWS_GROUP
APPLICATION_ROLE
DATABASE_ROLE
CERTIFICATE_MAPPED_USER
ASSYMETRIC_KEY_MAPPED_USER
In older versions of SQL Server, you can retrieve all Users by using the sys.sysusers table in SQL Server 2000. The command is as follows:
SELECT *COLLECTION NOTE uid user Id (unique numeric value) status Not applicable User name created in CREATE USER sid command Sid value is specified in the command CREATE LOGIN roles Not created createdate Date / Time created User by CREATE USER updatedate command Date / Time to edit User altuid Not apply password Not apply gid Group id assigned to User environ Not applicable hasdbaccess Value 0 or 1 islogin Value 0 or 1 isntname Value 0 or 1 isntgroup Value 0 or 1 isntuser Value 0 or 1 issqluser Value 0 or 1 isaliased Value 0 or 1 issqlrole Value 0 or 1 isapprole Value 0 or 1
FROM master.sys.sysusers;
See more:
Previous article: DROP USER command in SQL Server
The following article: Use annotations in SQL Server