Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 17:00:56 GMT


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


Subj:   Re: Related question to difference between database types
 
From:   Jason Fortenberry

I will bet what Jim is referring to is dynamic SQL in a stored procedure.

When specifically using dynamic sql, it is required that the creator = immediate owner. So for creator to equal immediate owner, you have to create the stored procedure under a user db (can't log in as an application database to be creator) and that user db has to have perm space. If it wasn't for the dynamic sql use this would not be an issue.

Jim, I sympathize with your position, at my site we don't allocate perm space to users either (well we didn't before this). But for dynamic sql procedures, we just had to gave those users a few MB of space to solve the problem.

--Jason



     
  <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