17.10 - Corresponding Tables and Logging Rules - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)
SQL procedure object information is stored in:
  • DBC.TVM
  • DBC.TVFields
  • DBC.AccessRights
  • DBC.AccLogRuleTbl
The SPObjectCodeRows column in the DBC.TVM table references information on the status of the SQL procedure. The value of this column indicates the following SQL procedure creation-time attributes:
  • Session mode
  • Platform type
  • Print option
  • SQL procedure text storage option
  • Version number
  • Warning option
  • Hardware architecture

The SPParameterType column in the DBC.TVFields table contains information about the SQL procedure parameters. Parameter types for this column include IN, INOUT, or OUT.

The following table lists the privileges stored in the AccessRights table and their corresponding logging rules stored in the AccLogRuleTbl table.

Privilege Logging Rule
CREATE OWNER PROCEDURE AcrCreOwnerProcedure
CREATE PROCEDURE AcrCreateProcedure
ALTER PROCEDURE AcrAlterProcedure
EXECUTE PROCEDURE AcrExecuteProcedure
DROP PROCEDURE AcrDropProcedure