sys.sysusers (Transact-SQL)
Contains one row for each Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database.
Important
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
| 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. For more information, see Querying the SQL Server System Catalog. |
status |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
name |
sysname |
User name or group name, unique in this database. |
sid |
varbinary(85) |
Security identifier for this entry. |
roles |
varbinary(2048) |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
createdate |
datetime |
Date the account was added. |
updatedate |
datetime |
Date the account was last changed. |
altuid |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Overflows or returns NULL if the number of users and roles exceeds 32,767. For more information, see Querying the SQL Server System Catalog. |
password |
varbinary(256) |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
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. For more information, see Querying the SQL Server System Catalog. |
environ |
varchar(255) |
Reserved. |
hasdbaccess |
int |
1 = Account has database access. |
islogin |
int |
1 = Account is a Windows group, Windows user, or SQL Server 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 SQL Server user. |
isaliased |
int |
1 = Account is aliased to another user. |
issqlrole |
int |
1 = Account is a SQL Server role. |
isapprole |
int |
1 = Account is an application role. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Compatibility Views (Transact-SQL)