sysusers

Columns for sysusers

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

suid

int

4

 

 

No

 

 

 

2

uid

int

4

 

 

No

 

 

 

3

gid

int

4

 

 

No

 

 

 

4

name

sysname

30

 

 

No

 

 

 

5

environ

varchar

255

 

 

Yes

 

 

 

 

Indexes for sysusers

Name

Attributes

Segment

Columns

sysusers

clustered

system

suid

ncsysusers1


unique

system

name

ncsysusers2


unique

system

uid

 

sp_primarykey defined for sysusers

#

Columns

1

suid

 

Incoming sp_foreignkeys coming into sysusers

1

sp_foreignkey coming from table sysalternates.
sysalternates.suid to column suid

 

Incoming sp_commonkeys coming into sysusers

1

sp_commonkey coming from table sysobjects.
sysobjects.uid to column uid

2

sp_commonkey coming from table systypes.
systypes.uid to column uid

3

sp_commonkey coming from table sysprotects.
sysprotects.uid to column uid

 

Permissions on sysusers

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo

 


Go to Sybase 12.5.2 User Database List of Tables.


Updated: Sun Dec 26 14:50:54 2004