 |
 |
Archives of the TeradataForum
Message Posted: Thu, 04 Feb 2010 @ 14:08:56 GMT
| Subj: | | Re: Issue in executing macro: An owner referenced by user |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, February 04, 2010 09:02 -->
The stored procedure is in effect "granting access" to the view to third parties (neither creator nor owner). So just as for views, the
"immediate owner" of a stored procedure (the database or user in which it is defined) must hold permissions WITH GRANT OPTION on the referenced
objects.
| |
