SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-9
Securing Catalog Tables
Examples
These examples show access to the catalog tables. Actual access for certain
statements can depend on the security of a table, view, or index.
The first example shows security that enables any network user to read or write to the
catalogs in which objects are registered. Any network user can compile and register
programs in this catalog and can create tables, views, and indexes. Only the super ID
user in the DBA user group can drop the catalog.
$VOL1.SUBVOL catalog Owner = 001,255
Security = "NNNO"
The next example shows security that enables any group 100 user to compile
programs that use tables and views described in the $VOL1.APPLPGM or
$VOL2.APPLCAT catalog:
$VOL1.APPLPGM catalog Owner = 100,255
Security = "GGNO"
$VOL2.APPLCAT catalog Owner = 001,255
Security = "NGOO"
$VOL2.APPLCAT.USAGES Owner = 001,255
Security = "NNOO"
$VOL2.APPLCAT.TRANSIDS Owner = 001,255
Security = "NNOO"
All programs for this application are registered in the catalog $VOL1.APPLPGM. Any
group 001 user can:
•
Read or write to the catalog $VOL2.APPLCAT in which the objects are described
•
Create tables, views, and indexes registered in this catalog (local users only)
•
Execute programs registered in $VOL1.APPLPGM
Any network user can query descriptions in the catalog $VOL2.APPLCAT. Only the
super ID user of each group can drop the catalog.
The next example shows security that enables any network group 001 user to read or
write to the catalog in which the objects are described or to execute programs
registered in the catalog $VOL2.APPLCAT. Only local group 001 users can create
dependencies on any objects described in the catalog or compile programs that use
any tables or views described in the catalog.
$VOL2.APPLCAT catalog Owner = 001,255
Security = "CCCO"
$VOL2.APPLCAT.USAGES Owner = 001,255
Security = "CGOO"
$VOL2.APPLCAT.PROGRAMS Owner = 001,255
Security = "CGOO"
$VOL2.APPLCAT.TRANSIDS Owner = 001,255
Security = "CGOO"