Requirements for Logging Certain Operations and Objects in Combination - 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™

The following table is an alphabetical listing of certain operations that have limitations when specified in a BEGIN LOGGING statement.

When specifying logging of this operation These conditions apply
ALL Does not include logging of the following operations, because they refer to system level objects that do not support an ON clause:
  • CREATE PROFILE
  • CREATE ROLE
  • DROP PROFILE
  • DROP ROLE
  • CREATE DATABASE
  • CREATE MACRO
  • CREATE PROCEDURE
  • CREATE TABLE
  • CREATE VIEW
  • CREATE USER
  • DROP DATABASE
  • DROP USER
The ON clause can only specify a database or user.
DROP TABLE The logging also includes ALTER TABLE, which requires the DROP table privilege.
DROP MACRO, DROP PROCEDURE, or DROP VIEW Also includes logging of REPLACE for the specified object.
DROP, EXECUTE or GRANT The only operations allowed if the ON clause specifies a macro or procedure.
DUMP, RESTORE or CHECKPOINT Are not allowed if the ON clause specifies a VIEW.
The single keyword representation of multiple SQL privileges, for example:
  • TABLE
  • VIEW
  • MACRO
  • TRIGGER
  • PROFILE
  • USER
  • PROCEDURE
  • ROLE
  • FUNCTION
  • UDTTYPE (covers UDTUsage/UDTType)
  • UDTMETHOD (covers UDTUsage/UDTType/UDTMethod)
  • AUTHORIZATION
  • GLOP
Logs all the privileges covered by the keyword. For example, specifying TABLE as the logging operation logs CREATE TABLE, ALTER TABLE, and DROP TABLE.

For a list of keywords that represent multiple privileges, see Teradata Vantage™ - SQL Data Control Language, B035-1149.

CREATE FUNCTION, DROP FUNCTION, EXECUTE FUNCTION, ALTER FUNCTION, or GRANT The only operations that can be specified if the ON clause specifies a FUNCTION (internal or external functions).
UDTMETHOD or UDTTYPE The ON clause must specify DATABASE or USER, and the database or user must be the SYSUDTLIB database.
UDTUSAGE The ON clause must specify one of the following:
  • DATABASE or USER, and the database or user must be the SYSUDTLIB database.
  • TYPE
ALTER EXTERNAL PROCEDURE, DROP PROCEDURE, EXECUTE PROCEDURE, and GRANT The only operations allowed on external procedures.