Requirements for Logging Certain Operations and Objects in Combination - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
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.