logged_item - 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™

One or more database objects for which access logging is to be discontinued. You can specify to end logging on up to 20 objects.

If you do not specify the ON keyword object_name option, the system applies the other end logging rules specified elsewhere in the statement to all objects.

Each object in the ON clause must be preceded by the keyword that indicates the object type: DATABASE, FUNCTION, FUNCTION MAPPING, MACRO, PROCEDURE, TABLE, TYPE, USER, or VIEW, followed by the object name.

The ON keyword object_name option does not apply to the CREATE PROFILE, DROP PROFILE, CREATE ROLE, or DROP ROLE operation because profiles and roles are system-level objects with no containing user or database.

DATABASE
For databases, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name.object_name.
FUNCTION
For functions, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name. object_name or user_name.object_name.
FUNCTION MAPPING
For function mappings, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name. object_name or user_name.object_name.
MACRO
For macros, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name. object_name.
PROCEDURE
For procedures, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name.object_name.
TABLE
For tables, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name.object_name.
USER
For users, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name.object_name.
VIEW
For views, you must specify a qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name.object_name.
qualified_object_name
A qualified object name that includes the name of the containing database or user. For example, database_name.object_name or user_name.object_name.
TYPE
For user defined types, the specification must always be SYSUDTLIB.UDT_name, for example:
ON TYPE SYSUDTLIB. UDT_name