Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 10:41:14 GMT

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

Subj:   Re: Dynamic SQL question about rights
From:   Sidana Sanjeev

If the Stored Procedure is making the use of Dynamic SQL, then the procedure should be created in user database only (this will be the user which should be executing the procedure).

For this, you also might need to assign some perm space to the user db, which is not ideally assigned.

Hope this helps.

  <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