Status on sysusers 1

[nickdel]

Hi, does anyone have a list of what each status is on the sysuser tables?

Thanks

Nick

 

[ptheriault]

If you search BOL for sysusers it will define each column.

Here is the status column
{quote]
Reserved for SQL Server internal use only. Future compatibility is not guaranteed
/quote]

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[nickdel]

Thanks Paul, dont suppose you could paste these on here for me could you? I'm at work and am not able to install anything on PC!

Nick

 

[ptheriault]

Here is the sysusers table definition.

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
Reserved for SQL Server internal use only. 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)
Reserved for SQL Server internal use only. Future compatibility is not guaranteed.

createdate
datetime
Date the account was added.

updatedate
datetime
Date the account was last changed.

altuid
smallint
Reserved for SQL Server internal use only. 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)
Reserved for SQL Server internal use only. 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.

Also Here is a link to the on-line version of BOL

http://technet.microsoft.com/en-us/library/ms950403.aspx

- Paul
- If at first you don't succeed, find out if the loser gets anything.