Archives of the TeradataForum
Message Posted: Tue, 30 Jul 2002 @ 16:24:00 GMT
| 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?