Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   SPL1078:E(L12), User is not authorized to use the DDL/DCL/Dynamic SQL statement.
 
From:   viva andary

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023