All databases
sysalternates contains one row for each Adaptive Server user that is 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.
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 |
Unique clustered index on suid.
