16.20 - Requirements for Logging Certain Operations and Objects in Combination - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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.