ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables

HP NonStop ODBC Server Reference Manual—429151-002

8-71

SYSUSERS Catalog View (ZVUUS)

The catalog view SYSUSERS contains usernames used only to qualify object names.

SYSUSERS is represented by a view over the mapping table ZNSUS.

The view and mapping table reside on each customized subvolume.

SYSUSERS is created when a catalog is customized. You can add users with the

NOSUTIL ADD USER statement. For information on this statement, see Running the

Catalog Utility Statements on page 7-13.

SYSUSERS is defined for each database, but it has the same values in all user

databases for a specific node. SQL Server, on the other hand, has distinct user lists for

each user database, and the special username DBO is reserved for the user who

creates the database.

SYSUSERS is loaded at the time of catalog customization with a row containing the

following values:

Table 8-38. Description of SYSUSERS

Column Name Column Name in ZNSUS Description

SUID None No corresponding column name.

Assigned –1.

UID ZNSUS.NOS_UID User ID used internally by the

NonStop ODBC Server.

GID None No corresponding column name.

Assigned –1.

NAME ZNSUS./NOS_USERNAME Logical username.

ENVIRON None No corresponding column name.

Assigned " " (blank).

Column Value

SUID –1

UID 1

GID –1

NAME DBO

ENVIRON " " (blank)