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

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢
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