ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-13
Authorization and Security
This tool is very useful for checking on the results of some of the tuning
recommendations made earlier. You are encouraged to experiment with different
options and to use the tool to evaluate the performance changes.
Authorization and Security
This subsection discusses the authorization needed on the NonStop system to perform
actions within the NonStop ODBC Server environment. Security issues related to the
PC, workstation, or LAN are not covered here.
Authorization is based on Guardian user names. The NonStop ODBC Server
programs, NOS and NOSUTIL, that manage SQL/MP objects are regular SQL/MP
programs, and as such they are subject to the normal SQL/MP rules that govern the
access to SQL/MP objects. For example, to be able to create a table, the NOS process
executing the request must have read/write access to the associated SQL/MP catalog
tables, as well as read/write access to the NonStop ODBC Server catalog tables.
The actions you can do related to the NonStop ODBC Server are as follows:
The objects that the preceding actions involve are as follows:
Action Description
NOSINST Install NOS, NOSUTIL object files, build NonStop ODBC Server
SYSCAT
NOSUTIL START Start SCS and NonStop ODBC Servers
NOSUTIL ADD/DEL Add/Delete user, alias, profile, trace
NOSUTIL SYSCAT Install, deinstall, validate, refresh, cleanup NonStop ODBC Server
SYSCAT
NOSUTIL USERCAT Install, deinstall, validate, refresh, cleanup NonStop ODBC Server
USERCAT
CLIENT Connect and use NonStop ODBC Server
ADMIN Perform NonStop ODBC Server system administration
Object Description
SQL/MP SYSCAT SQL/MP system catalog
SQL/MP USERCAT SQL/MP user catalog
NonStop ODBC Server SYSCAT NonStop ODBC Server system catalog
NonStop ODBC Server USERCAT NonStop ODBC Server user catalog
SCSOBJ SCS object file
NonStop ODBC Server NonStop ODBC Server object file (NOS)
NonStop ODBC Server Utility Utility program object file (NOSUTIL) and its
interfaces, NOSCOM (NonStop product) and the
NonStop ODBC Server Configuration Manager
(PC-based)
SQLCOMP SQL/MP compiler