Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 10:51:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Dear All

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.

Veronica

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>