Applies to all databases. sysalternates contains one row for each SAP ASE user that is mapped or aliased to a user of the current database. When a user tries to access a database, the SAP ASE 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.