END LOGGING Examples | Teradata Vantage - 17.05 - END LOGGING Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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;