16.10 - Logging MODIFY Statements - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

While most SQL statements require database privilege checks and therefore generate log entries, MODIFY is not a privilege that you can grant, so the system does not check MODIFY privileges.

Because users must have the DROP privilege to use MODIFY, you can specify the DROP privilege in BEGIN LOGGING statements for the DATABASE, PROFILE, or USER modified, to log MODIFY activities.