Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



sysusers System Table - SQL Server 2000

Modified on Fri, May 01, 2009, 11:05 AM by Administrator Categorized as SQL Server System Tables
Contains one row for each Microsoft® Windows user, Windows group, Microsoft SQL Server™ user, or SQL Server role in the database.

Column nameData typeDescription
uidsmallintUser ID, unique in this database. 1 is the database owner.
statussmallintFor internal use only.
namesysnameUsername or group name, unique in this database.
sidvarbinary(85)Security identifier for this entry.
rolesvarbinary(2048)For internal use only.
createdatedatetimeDate the account was added.
updatedatedatetimeDate the account was last changed.
altuidsmallintFor internal use only.
passwordvarbinary(256)For internal use only.
gidsmallintGroup ID to which this user belongs. If uid = gid, this entry defines a group.
hasdbaccessint1, if the account has database access.
isloginint1, if the account is a Windows group, Windows user, or SQL Server user with a login account.
isntnameint1, if the account is a Windows group or Windows user.
isntgroupint1, if the account is a Windows group.
isntuserint1, if the account is a Windows user.
issqluserint1, if the account is a SQL Server user.
isaliasedint1, if the account is aliased to another user.
issqlroleint1, if the account is a SQL Server role.
isapproleint1, if the account is an application role.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.