Operations for which log entries should no longer be made.
- ALL
- Log entries are not made if any of the following actions are attempted against the specified object. ALL does not include the CREATE ROLE, DROP ROLE, CREATE PROFILE, or DROP PROFILE actions, because they do not apply to a specific object.
- The name and ID for each column are logged when you log privileges to INSERT, REFERENCES, SELECT, and UPDATE.
- If logging has already begun for ALL actions on an object, a subsequent request to begin or end logging changes logging activity only for the specified action.
- operation
- One or more SQL statement types from the following list to define the actions on which logging is to end for the specified objects and users.
- ALTER EXTERNAL PROCEDURE
- ALTER FUNCTION
- ALTER GROUP
- ALTER PROCEDURE
- CHECKPOINT
- CREATE AUTHORIZATION
- CREATE DATABASE
- CREATE EXTERNAL PROCEDURE
- CREATE FUNCTION
- CREATE GLOP SET
- CREATE GROUP
- CREATE MACRO
- CREATE PROCEDURE
- CREATE PROFILE
- CREATE ROLE
- CREATE TABLE
- CREATE TRIGGER
- CREATE USER
- CREATE VIEW
- DATABASE
- DELETE
- DROP
- DROP AUTHORIZATION
- DROP DATABASE
- DROP FUNCTION
- DROP GLOP SET
- DROP GROUP
- DROP MACRO
- DROP PROCEDURE
- DROP PROFILE
- DROP ROLE
- DROP TABLE
- DROP TRIGGER
- DROP USER
- DROP VIEW
- DUMP
- EXECUTE
- EXECUTE FUNCTION
- EXECUTE PROCEDURE
- GRANT
- INDEX
- INSERT
- MACRO
- OVERRIDE DELETE CONSTRAINT
- OVERRIDE DUMP CONSTRAINT
- OVERRIDE INSERT CONSTRAINT
- OVERRIDE RESTORE CONSTRAINT
- OVERRIDE SELECT CONSTRAINT
- OVERRIDE UPDATE CONSTRAINT
- PROCEDURE
- REFERENCES
- RESTORE
- ROLLBACK DATABASE
- ROLLFORWARD DATABASE
- SELECT
- TABLE
- TRIGGER
- UDTMETHOD
- UDTTYPE
- UDTUSAGE
- UPDATE
- USER
- VIEW
- GRANT
- Specifies that logging is to end on all GRANT statements for the specified objects and users.