15.10 - ON operation Clause - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Operations for which log entries should no longer be made.

ALL
Log entries are not made if any of the actions listed below 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.

Example 1:  Stopping UDT Logging And SQL Text

This example stops logging the SQL text for the failed attempts.

     END LOGGING DENIALS WITH TEXT ON UDTTYPE;

Example 2:  Stopping UDT Logging On a UDT Type

This example stops logging for all of the following attempts that failed because of insufficient privileges.

  • ALTER TYPE
  • CREATE CAST
  • CREATE ORDERING
  • CREATE TRANSFORM
  • CREATE TYPE
  • DROP CAST
  • DROP ORDERING
  • DROP TRANSFORM
  • DROP TYPE
  • REPLACE CAST
  • REPLACE ORDERING
  • REPLACE TRANSFORM
  • method invocation
  • NEW specification
  • UDT reference
         END LOGGING DENIALS ON UDTTYPE;

Example 3: Stopping UDT Logging On a UDT Method

This example stops logging for all of the following request attempts that fail because of insufficient privileges.

  • ALTER METHOD
  • ALTER TYPE
  • CREATE CAST
  • CREATE METHOD
  • CREATE ORDERING
  • CREATE TRANSFORM
  • CREATE TYPE
  • DROP CAST
  • DROP METHOD
  • DROP ORDERING
  • DROP TRANSFORM
  • DROP TYPE
  • REPLACE CAST
  • REPLACE ORDERING
  • REPLACE TRANSFORM
  • method invocation
  • NEW specification
  • UDT reference
         END LOGGING ON UDTMETHOD;