17.00 - Corresponding Tables and Logging Rules - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
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