ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-40
Accounting Log (ACC_LOG) Statements
Accounting Log (ACC_LOG) Statements
Use the following statements for NonStop ODBC Server accounting log tables:
•
CREATE ACC_LOG
•
DROP ACC_LOG
CREATE ACC_LOG
The CREATE ACC_LOG statement creates a new accounting log table named
ZNUMTRX and registers the table as a NonStop ODBC Server object in a database.
IN database
specifies the name of the database in which to register the new accounting log
table. database must be a customized NonStop ODBC Server database;
otherwise, the statement returns an error.
SECURE security-string
is a four-character alphabetic string that specifies the Guardian read, write,
execute, and purge (RWEP) access for the accounting log table. For more
information about security for NonStop SQL/MP objects, see the “Security” entry in
the NonStop SQL/MP Reference Manual.
Considerations – CREATE ACC_LOG
The CREATE ACC_LOG statement returns an error if the associated SQL CREATE
TABLE statement fails for resource or privilege reasons.
UMAP
ADD UMAP
MODIFY UMAP
REMOVE UMAP
Mapping of user and profile to a server class
USER
ADD USER
MODIFY USER
REMOVE USER
Mapping of logical usernames to
Guardian
usernames
VIEW
ADD VIEW
REMOVE VIEW
Visibility of NonStop SQL/MP views
CREATE ACC_LOG IN database [ SECURE security-string ]
Table 7-4. Summary of Mapping Table Statements (page 3 of 3)
Statement Type What This Type of Statement Affects