syblicenseslog  sysattributes

Chapter 1: System Tables

sysalternates

All databases

Description

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.

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





Copyright © 2005. Sybase Inc. All rights reserved. sysattributes

View this book as PDF