All databases
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.
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 |
