Logging Self-Referent MODIFY USER Statements - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
By default, database users have the privilege to modify certain parameters in their user definition. When users submit a self-referent MODIFY USER request to change any of the following parameters, the system does not check any privileges:
  • AFTER JOURNAL
  • BEFORE JOURNAL
  • COLLATION
  • DEFAULT DATABASE
  • DEFAULT JOURNAL TABLE
  • PASSWORD
  • STARTUP

The system does no privilege checks on such requests, and therefore performs no logging.