Archives of the TeradataForum
Message Posted: Mon, 06 Aug 2007 @ 10:51:33 GMT
I am trying to create a procedure, when I run it, I received an error SPL1078:E(L12), User is not authorized to use the DDL/DCL/Dynamic SQL statement.
I was reading about it, they said the creator and the user are different. I am connecting by the DBC user (DBC is supposed to be the creator and the user)
I don't understand what should I do??
Thanks for clarifying.
this is the procedure:
CREATE PROCEDURE DEV_STG_CORE.RENAME_TABLES() BEGIN DECLARE V_DATE DATE; DECLARE T_NAME VARCHAR(45); SET V_DATE= ADD_MONTHS(add_months(DATE- (extract(day from DATE) - 1), 1) -1,-1); SET T_NAME='DEV_TAB.DAILY_CUST_ACCOUNT_BAL_'||V_DATE; CALL DBC.SysExecSQL('RENAME TABLE DEV_TAB.DAILY_CUST_ACCOUNT_BAL_'||:V_DATE); END
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|