sys-sysusers-transact-sql.md

title	sys.sysusers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
ms.prod_service	database-engine, sql-data-warehouse, pdw
ms.service
ms.component	system-compatibility-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.sysusers sys.sysusers_TSQL sysusers_TSQL sysusers
dev_langs	TSQL
helpviewer_keywords	sysusers system table sys.sysusers compatibility view
ms.assetid	5f0e6a8d-c983-44f6-97e9-aab5bff67d18
caps.latest.revision	36
author	BYHAM
ms.author	rickbyh
manager	jhubbard
ms.workload	On Demand

sys.sysusers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]

Contains one row for each [!INCLUDEmsCoName] Windows user, Windows group, [!INCLUDEmsCoName] [!INCLUDEssNoVersion] user, or [!INCLUDEssNoVersion] role in the database.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
uid	smallint	User ID, unique in this database. 1 = Database owner Overflows or returns NULL if the number of users and roles exceeds 32,767.
status	smallint	[!INCLUDEssInternalOnly]
name	sysname	User name or group name, unique in this database.
sid	varbinary(85)	Security identifier for this entry.
roles	varbinary(2048)	[!INCLUDEssInternalOnly]
createdate	datetime	Date the account was added.
updatedate	datetime	Date the account was last changed.
altuid	smallint	[!INCLUDEssInternalOnly] Overflows or returns NULL if the number of users and roles exceeds 32,767.
password	varbinary(256)	[!INCLUDEssInternalOnly]
gid	smallint	Group ID to which this user belongs. If uid is the same as gid, this entry defines a group. Overflows or returns NULL if the combined number of groups and users exceeds 32,767.
environ	varchar(255)	Reserved.
hasdbaccess	int	1 = Account has database access.
islogin	int	1 = Account is a Windows group, Windows user, or [!INCLUDEssNoVersion] user with a login account.
isntname	int	1 = Account is a Windows group or Windows user.
isntgroup	int	1 = Account is a Windows group.
isntuser	int	1 = Account is a Windows user.
issqluser	int	1 = Account is a [!INCLUDEssNoVersion] user.
isaliased	int	1 = Account is aliased to another user.
issqlrole	int	1 = Account is a [!INCLUDEssNoVersion] role.
isapprole	int	1 = Account is an application role.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)