ALLBASE/SQL Reference Manual (36216-90216)

566 Chapter12
SQL Statements S - Z
START DBE NEWLOG
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 This includes audit logging of the following statements:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
DROP 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 This includes audit logging of the following statements:
CREATE DBEFILE
DROP DBEFILE
ADD DBEFILE TO DBEFILESET
REMOVE DBEFILE FROM DBEFILESET
CREATE TEMPSPACE
DROP TEMPSPACE
AUTHORIZATION This includes audit logging of the following statements:
GRANT
REVOKE
ADD TO GROUP
REMOVE FROM GROUP
SECTION This includes audit logging of the creation and deletion of
permanent sections. Permanent sections are created when
a program is preprocessed, and are deleted by the DROP
MODULE statement. Logging of section creation does not
include any SETOPT information associated with the
section. See the SETOPT statement in this chapter.
ALL This is equivalent to specifying COMMENT DATA
DEFINITION STORAGE AUTHORIZATION SECTION
AUDIT ELEMENTS as described above.
NewLogDefinition is a clause that provides ALLBASE/SQL with the information
needed to create one or more new log files. The syntax for this clause is
presented in the next section.