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