ALLBASE/SQL Reference Manual (36216-90216)

558 Chapter12
SQL Statements S - Z
START DBE NEW
the LOG COMMENT statement returns an error.
DATA is the default element. It causes audit log records to be
done for any data operations (INSERT, UPDATE, or
DELETE) on tables that are in an audit partition of the
DBEnvironment other than NONE. (Tables can be
specified to be in partition NONE and thus not participate
in the audit logging process.)
DEFINITION includes audit logging of the following statements:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
CREATE VIEW
DROP VIEW
CREATE RULE
DROP RULE
CREATE PROCEDURE
DROP PROCEDURE
TRANSFER OWNERSHIP
CREATE GROUP
DROP GROUP
CREATE DBEFILESET
DROP DBEFILESET
CREATE PARTITION
DROP PARTITION
TRUNCATE TABLE
STORAGE includes audit logging of the following statements:
CREATE DBEFILE
DROP DBEFILE
ADD DBEFILE TO DBEFILESET
REMOVE DBEFILE FROM DBEFILESET
CREATE TEMPSPACE
DROP TEMPSPACE
AUTHORIZATION includes audit logging of the following statements:
GRANT
REVOKE
ADD TO GROUP
REMOVE FROM GROUP
SECTION includes audit logging of the creation and deletion of
permanent sections or procedures. Permanent sections or
procedures are created when a program is preprocessed,
and are deleted by the DROP MODULE statement. The DROP
PROCEDURE statement deletes procedures. Logging of
section creation does not include any SETOPT information
associated with the section. See the SETOPT statement.
ALL is equivalent to specifying COMMENT DATA
DEFINITION STORAGE AUTHORIZATION SECTION