Archives of the TeradataForum
Message Posted: Wed, 06 Nov 2002 @ 17:00:56 GMT
| 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
| 
