Archives of the TeradataForum
Message Posted: Wed, 06 Nov 2002 @ 17:00:56 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|