Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 12:32:05 GMT

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

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

Being DBC there are some restrictions.

Now you are trying to create a procedure under a different user - "DEV_STG_CORE".

For this to work either you should grant permission to DBC to be able to create the stored procedure under user "DEV_STG_CORE" - "grant create procedure on DEV_STG_CORE TO DBC;" and then you compile your procedure.

Or you need to change the context of your current user to "DEV_STG_CORE" - by either the ".logon username" or through "Database <username>;" and then compile your stored procedure.

I hope the procedure that you have listed is placed a separate file and that you tried to compile that file when you received this error.


  <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