ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables

HP NonStop ODBC Server Reference Manual—429151-002

8-27

ZNSPROT (For User Permission Data)

The table ZNSPROT contains user permission information. It has one row for each

combination of T_ACTION and T_PROTECTTYPE. The table is implemented to

provide compatibility with the SQL Server system table SYSPROTECTS. The NonStop

ODBC Server, however, does not support the statements that affect SYSPROTECTS,

so ZNSPROT grants all users authority to use all statements.

ZNSPROT resides only in the subvolume of the system catalog.

See also SYSPROTECTS Catalog View (ZVUPROT) on page 8-69.

Table 8-13. Description of ZNSPROT

Column Name

Primary Key

Unique Index

Data Type Description

T_ACTION

––

INT (2) An integer corresponding to a

Transact-SQL statement:

193 SELECT

195 INSERT

196 DELETE

197 UPDATE

224 EXECUTE

T_PROTECTTYPE

––

INT (2) Protection type. Contains the

integer 205, which signifies

GRANT permission.

x Indicates the column is part of the primary key or is a unique index

– Indicates the column is not part of the primary key or is not a unique index