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 |