Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 28 Feb 2006 @ 13:01:55 GMT


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


Subj:   Re: Compilation problems when try to compile the proceudre
 
From:   Victor Sokovin

Hi Srikanth,

  For the stored procedure I have created both the creation and the owner is same.  


  Can you pls. explain me in detail.  


I thought it might be worth checking when I saw

     replace procedure d_dba.enableAuditLog()

in your posting.

Looks like you are trying to create the SP in a database which is not yours. D_DBA becomes the owner of the procedure in this case, and your user ID is the creator.

Try to create the same procedure as the owner of D_DBA (or ask your DBA to create it for you) to see whether this resolves the issue.


Victor



     
  <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