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. |