Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 30 Jul 2002 @ 16:24:00 GMT


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


Subj:   Re: Macro Possibilities?
 
From:   Jason Fortenberry

Well our design was that no users would have perm space and all objects (views, tables, macros, etc) would be created under true "application databases" not user databases. The pros and cons to this are very much debatable, but the decision was made and is now simply how things are.

But when specifically using dynamic sql, it is required that the creator = immediate owner. This violates our policy where creator places object under another application database (immediate owner). So for creator to equal immediate owner, I had to create the stored procedure under a user db (can't log in as an application database to be creator) and that user db had to have perm space. If it wasn't for the dynamic sql use this would not have been an issue. Rights were not the problem, it was this creator = immediate owner issue. Perhaps someone knows a better way around this?



     
  <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