Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 13:53:02 GMT

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

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

Dear Viva,

You can create procedure using Dynamic SQL only in the user database who has logged in. In your case you are logged in as DBC but are creating the procedure in database DEV_STG_CORE. You must have the user created as dev_stg_core, login as that and then create the procedure. I guess DEV_STG_CORE is the database and not the user in your case. In that case, login as some user and then create the procedure in that user database.


Rajesh Jain

  <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: 28 Jun 2020