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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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;