16.20 - Corresponding Tables and Logging Rules - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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