NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
P-31
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.
PURGE Command
PURGE is an SQLCI utility that deletes SQL objects (except catalog tables and their
indexes), SQL programs in Guardian files, and Enscribe files. For an SQL object,
PURGE deletes the file that contains the object, the catalog entries for the object, and
objects (but not programs) that depend upon the object.
The local super ID (but not other users) can also use PURGE to delete shadow labels.
You cannot PURGE constraints or catalogs. Use DROP instead.
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
Column Name Data Type Description
* Indicates primary key