Stored Procedure Compilation (SPL Prefix) Message SPL1078 - SPL1078 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Message
- "%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 are not the same. Hence the DDL, DCL or dynamic SQL statement cannot be specified in the SPL source text.
- Generated By
- TSP module.
- For Whom
- End user.
- Notes
- None
- Remedy
- Ensure that either the creator and the immediate owner of the stored procedure are the same or do not use the DDL DCL and/or dynamic SQL statements in the SPL source text.