ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-24
Troubleshooting Security Problems
Troubleshooting Security Problems
If you are having trouble installing or creating objects, check for the necessary security.
Client applications do not always relay detailed error information (instead, they report
something like “server failure”). See Tracing
on page 4-34 to learn how to use tracing
to display error information.
A quick check for clients that have problems is to run again as the super ID. If this
strategy works, look for a security problem.
If you have problems bringing the NonStop ODBC Server system up, check the
security of the NonStop ODBC Server program files and the security of the NonStop
ODBC Server system catalog tables and the file $SYSTEM.SYSTEM.ODBCMSG. In
the event of security errors in these areas, you should receive errors reported to the
EMS log.
ADD PROCEDURE User 255,127 can insert into
tables ZNSPROC and
ZNSPCOL in the current
catalog.
The procedure entry is added. If
the procedure name did not
indicate owner qualification, the
invoking logical username is
used. For example,
ADD PROCEDURE p1 $m s1
would add
NODE_DISK1_DB1.SQL_
USER1.P1.
REMOVE USER User 255,127 can delete rows
from the table ZNSUS in the
SQL system catalog.
ZNSUS is changed.
REMOVE ALIAS User 255,127 can delete rows
from the table ZNSALT in the
SQL system catalog.
ZNSALT is changed.
REMOVE PROFILE User 255,127 can delete rows
from ZNSPROF.
ZNSPROF is changed.
REMOVE TRACE User 255,127 can delete rows
from ZNSTRA.
ZNSTRA is changed.
REMOVE
PROCEDURE
User 255,127 can delete rows
from tables ZNSPROC,
ZNSPCOL in the current
catalog.
The procedure entry is deleted.
If the procedure name did not
indicate owner qualification, the
invoking logical username is
used. For example, REMOVE
PROCEDURE p1 would delete
NODE_DISK1_DB1.SQL_
USER1.P1.
Table 4-2. Effect of PROGID Security on NOSUTIL Operations (page 3 of 3)
Command Conditions Met Results