valid_user(user_id)
Determines whether the specified ID is a valid user or alias in at least one database in the ASE server. If valid, it returns 1, otherwise 0. Detailed explanation: An ID is a valid ID if 1) in at least one of the databases the table ‘sysusers
’ contains a record with ‘uid
’ equal to the ID, and/or 2) if in at least one of the databases the table ‘sysalternates
’ (the table that stores alias information) contains a record with ‘suid
’ equal to the ID.
Example
select valid_user(32)