SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-32
Protection View
The columns PROGRAMNAME through CLEARONPURGE (1 through 10) were
created in version 1. Columns SECURITYMODE through
PROGRAMCATALOGVERSION (11 through 13) were added in version 300. Columns
FORCE through REGISTERONLY (14 through 18) were added in version 310. Column
OSSFILE (19) was added in version 315.
Guardian names in the PROGRAMS table are fully qualified and use uppercase
characters. Names of OSS files are stored as the corresponding ZYQ Guardian
names, not OSS pathnames.
Protection View
A protection view is a view defined with the FOR PROTECTION option of the CREATE
VIEW statements. The view can be derived from a single table by taking a projection of
the columns of the table, a restriction of the rows in the table, or both.
A protection view provides a form of column-level security, because the protection view
can be secured independently of the table.
12 PROGRAMFORMATVERSION PFV of program (oldest version of SQL that
can execute program)
SMALLINT
UNSIGNED
13 PROGRAMCATALOGVERSION PCV of program (oldest version catalog that
can register program)
SMALLINT
UNSIGNED
14 FORCE CHAR(1) Y if FORCE specified
N if not
15 SIMILARITYINFO CHAR(1) Y if similarity info stored
N if not
16 RECOMPILEMODE VARCHAR(30) ALL -RECOMPILEALL
ON_DEMAND -RECOMPILEONDEMAND
UNKNOWN -pre version 310
17 CHECKMODE VARCHAR(30) Value of CHECK clause:
INVALID_PROGRAMS (default)
INVALID_PLANS
INOPERABLE_PLANS
18 REGISTERONLY CHAR(1) Y if REGISTERONLY specified
N if not
19 OSSFILE CHAR(1) Y if OSS file
N if not
* Indicates primary key
Table P-2. The PROGRAMS Table (page 2 of 2)
Column Name Data Type Description