SPL1078: "%s:E(L%d), User is not authorized to use the DDL/DCL/Dynamic SQL statement." - Teradata Database

Stored Procedure Compilation (SPL Prefix) Messages

Product
Teradata Database
Release Number
16.10
Language
English (United States)
Last Update
2018-10-22
dita:id
B035-1096-SPL
lifecycle
archive
Product Category
Teradata® Database

SPL1078: "%s:E(L%d), User is not authorized to use the DDL/DCL/Dynamic SQL statement."

Explanation:

The reason is that the creator and the immediate owner of the stored procedure is not the same. Hence the specified DDL, DCL, or dynamic SQL statement cannot be specified in the SPL source text.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Either ensure that the creator and the immediate owner of the stored procedure is the same, or do not use the DDL, DCL, and/or dynamic SQL statements in the SPL source text.