ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-23
PROGID Security
User Catalog Commands for Existing SQL Catalogs
CLEANUP For a user catalog, same as
USERCAT REFRESH; for the
system catalog, same as
SYSCAT REFRESH.
All temporary tables are
removed.
User Catalog Commands for Empty Subvolumes
USERCAT INSTALL
$disk1.dbb
User 255,127 can create views
against local SQL tables in
$disk1.dbb and against ZNSDT,
USAGES, ZNSUS in the SQL
system catalog.
The NonStop ODBC mapping
tables and the SQL catalog are
created with owner 255,127
and file security “NNNO.”
USERCAT DEINSTALL
disk1.dbb CASCADE
NSSQL
User 255,127 can drop tables,
indexes, and views composing
NonStop ODBC mapping tables
and the SQL catalog tables.
The NonStop ODBC mapping
tables and the SQL catalog are
dropped.
USERCAT REFRESH
$disk1.dbb
Same as USERCAT INSTALL;
also, user 255,127 can
READ/WRITE against the
NonStop ODBC mapping
tables.
Same as USERCAT INSTALL
for any object re-created.
USERCAT UPGRADE
$disk1.dbb
Same as USERCAT
REFRESH.
Same as USERCAT
REFRESH.
USERCAT VALIDATE
$disk1.dbb
Similar to USERCAT
REFRESH that requires only
READ access.
None—no updates occur.
CLEANUP For a user catalog, same as
USERCAT REFRESH; for the
system catalog, same as
SYSCAT REFRESH.
All temporary tables are
removed.
Other Management Commands
ADD USER User 255,127 can enter data
into the table ZNSUS in the
SQL system catalog.
ZNSUS is changed.
ADD ALIAS User 255,127 can insert into the
table ZNSALT in the SQL
system catalog.
ZNSALT is changed.
ADD PROFILE User 255,127 can insert into
ZNSPROF.
ZNSPROF is changed.
ADD TRACE User 255,127 can insert into
ZNSTRA.
ZNSTRA is changed.
Table 4-2. Effect of PROGID Security on NOSUTIL Operations (page 2 of 3)
Command Conditions Met Results