Access Logging - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

Any zone user with EXECUTE privilege on the DBC.AccLogRule macro can begin and end logging on objects within the zone, but not on objects outside their zone. Zone users cannot create an ON ALL log rule and they cannot end system-level logging rules that were created by non-zone users.

Users who have system-wide logging privileges can begin and end logging on all non-zone database objects. They cannot create log rules on zone database objects. They cannot end zone-level logging rules that zone users created. Users with system-wide logging privileges are the DBC user and any non-zone users, including zone guests, who have ZONE OVERRIDE privilege and EXECUTE privilege on the DBC.AccLogRule macro.