sysremotelogins

Columns for sysremotelogins

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

remoteserverid

smallint

2

 

 

No

 

 

 

2

remoteusername

varchar

30

 

 

Yes

 

 

 

3

suid

int

4

 

 

No

 

 

 

4

status

smallint

2

 

 

No

 

 

 

 

Indexes for sysremotelogins

Name

Attributes

Segment

Columns

csysremotelogins

unique
clustered

default

remoteserverid, remoteusername

 

sp_primarykey defined for sysremotelogins

#

Columns

1

remoteserverid
remoteusername

 

Outgoing sp_commonkeys from sysremotelogins

1

sp_commonkey references table sysusers.
Column suid to sysusers.suid

 

Incoming sp_commonkeys coming into sysremotelogins

1

sp_commonkey coming from table sysservers.
sysservers.srvid to column remoteserverid

 

Permissions on sysremotelogins

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo

 


Go to Sybase 12.5 Master DB System Tables.


Updated: Sun Sep 29 12:56:19 2002