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

Teradata® Vantage - Database Stored Procedure Compilation (SPL Prefix) Messages

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

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.