15.10 - Example: Logging UDTs - 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

This example begins logging 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
         BEGIN LOGGING DENIALS 
         ON EACH UDTTYPE;