sysusers (T-SQL)

Contains one row for each Microsoft® Windows NT® user, Windows NT group, Microsoft SQL Server™ user, or SQL Server role in the database.

Column name Data type Description
uid smallint User ID, unique in this database. 1 is the database owner.
status smallint For internal use only.
name sysname Username or group name, unique in this database.
sid varbinary(85) Security identifier for this entry.
roles varbinary(2048) For internal use only.
createdate datetime Date the account was added.
updatedate datetime Date the account was last changed.
altuid smallint For internal use only.
password varbinary(256) For internal use only.
suid smallint Server user ID, copied from syslogins. A suid of 1 is the system administrator; -1 is a guest account.
gid smallint Group ID to which this user belongs. If uid = gid, this entry defines a group. The public role has a suid equal to -2. All other roles have a suid equal to -gid.
environ varchar(255) Reserved.
hasdbaccess int 1, if the account has database access.
islogin int 1, if the account is a Windows NT group, Windows NT user, or SQL Server user with a login account.
isntname int 1, if the account is a Windows NT group or Windows NT user.
isntgroup int 1, if the account is a Windows NT group.
isntuser int 1, if the account is a Windows NT user.
issqluser int 1, if the account is a SQL Server user.
isaliased int 1, if the account is aliased to another user.
issqlrole int 1, if the account is a SQL Server role.
isapprole int 1, if the account is an application role.


(c) 1988-98 Microsoft Corporation. All Rights Reserved.