Skip to content

sys-sysusers-transact-sql.md

Latest commit

 

History

History
65 lines (59 loc) · 3.64 KB

sys-sysusers-transact-sql.md

File metadata and controls

65 lines (59 loc) · 3.64 KB

title: "sys.sysusers (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: sql ms.prod_service: "database-engine, sql-data-warehouse, pdw" ms.component: "system-compatibility-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects 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: "rothja" ms.author: "jroth" manager: craigg monikerRange: ">=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"

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)