Error 916

Severity

14

Message text

Server user id %d is not a valid user in database '%.*s'

Explanation

When a user tries to open a database, Adaptive Server performs the following checks to determine the validity of the user:

  1. Looks for the suid (Adaptive Server user ID, copied from syslogins) of the process in sysusers to find the corresponding uid (user ID, unique in this database) and gid (group ID to which this user belongs).

  2. Looks for a “guest” row in sysusers (the suid for “guest” is -1).

  3. Looks for the user ID in sysalternates.

  4. Checks sysusers to determine whether the user has “sso” role if the user does have an suid in the database. This check is related to Adaptive Server auditing.

Error 916 occurs when a user tries to open a database and Adaptive Server finds that the user ID is not valid.

Action

Decide whether you want the user to access the database with:

If error 916 occurs after the above actions have been taken, call Sybase Technical Support.

Additional information

Refer to Reference Manual: Procedures for information about sp_addlogin, sp_adduser, and sp_addalias.

Have the information listed in “Reporting errors” ready when you call Sybase Technical Support, including the output from:

Versions in which this error is raised

All versions