ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-22
PROGID Security
Table 4-2. Effect of PROGID Security on NOSUTIL Operations (page 1 of 3)
Command Conditions Met Results
System Catalog Commands
SYSCAT INSTALL User 255,127 can create tables,
indexes, and views in the SQL
system catalog.
The NonStop ODBC mapping
tables are created with owner
255,127 and file security
“NNNO.”
SYSCAT DEINSTALL User 255,127 can drop tables,
indexes, and views composing
NonStop ODBC mapping
tables.
The NonStop ODBC mapping
tables are dropped.
SYSCAT REFRESH Same as SYSCAT INSTALL;
also, user 255,127 can
READ/WRITE against the
NonStop ODBC mapping
tables.
Same as SYSCAT INSTALL for
any object re-created (a
missing mapping table, for
example).
SYSCAT UPGRADE Same as SYSCAT REFRESH. Same as for REFRESH.
SYSCAT VALIDATE Similar to SYSCAT REFRESH
that requires only READ
access.
None—no updates occur.
User Catalog Commands for Existing SQL Catalogs
USERCAT INSTALL
$disk1.dba
User 255,127 can create views
against local SQL tables in
$disk1.dba and against ZNSDT,
USAGES, ZNSUS in the SQL
system catalog.
The NonStop ODBC mapping
tables are created with owner
255,127 and file security
“NNNO.”
USERCAT DEINSTALL
disk1.dba
User 255,127 can drop tables,
indexes, and views composing
NonStop ODBC mapping
tables.
The NonStop ODBC mapping
tables are dropped.
USERCAT REFRESH
$disk1.dba
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.dba
Same as USERCAT
REFRESH.
Same as USERCAT
REFRESH.
USERCAT VALIDATE
$disk1.dba
Similar to USERCAT
REFRESH that requires only
READ access.
None—no updates occur.