ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables

HP NonStop ODBC Server Reference Manual—429151-002

8-69

SYSPROTECTS Catalog View (ZVUPROT)

The catalog view SYSPROTECTS is created when the NonStop ODBC Server is

installed. It is provided for DBLIB users only. It reports all rights against all objects

registered in the local ZNOBJ objects table.

SYSPROTECTS is represented by a join view over ZNSPROT and ZNUOBJ. The view

and mapping table reside on each customized subvolume.

Table 8-36. Description of SYSPROTECTS

Column Name Column Name in ZNSUS Description

ID None No corresponding column name.

Assigned –1.

UID ZNSUS.NOS_UID User ID used internally by the

NonStop ODBC Server.

ACTION None An integer corresponding to a

Transact-SQL statement:

193 SELECT

195 INSERT

196 DELETE

197 UPDATE

224 EXECUTE

PROTECTTYPE None An integer, 205, corresponding to

GRANT permission. REVOKE (206)

is not supported. When using the

NonStop ODBC Server, all users are

granted permission for all statements.

COLUMNS None Column list to which the permission

applies.