sysalternates

All databases

Description

sysalternates contains one row for each Adaptive Server user mapped (or aliased) to a user of the current database. When a user tries to access a database, Adaptive Server looks for a valid uid entry in sysusers. If none is found, it looks in sysalternates.suid. If the user’s suid is found there, he or she is treated as the database user whose suid is listed in sysalternates.altsuid.

On the Adaptive Server distribution media, there are no entries in sysalternates.

Columns

The columns for sysalternates are:

Name

Datatype

Description

suid

int

Server user ID of user being mapped

altsuid

int

Server user ID of user to whom another user is mapped

Indexes

Unique clustered index On suid.