Archives of the TeradataForum
Message Posted: Wed, 30 Jun 2004 @ 15:49:01 GMT
| Subj: || || Re: Stored procedure permissions |
| From: || || Anomy Anom |
<-- Anonymously Posted: Wednesday, June 30, 2004 11:45 -->
If a user other than the owner utilizes a view (or stored procedure), then all of the relevant privileges needed by the owner of the view to
access underlying tables and views must be held by the owner of the view WITH GRANT OPTION.
Distinguish between creator and owner. The user that created the sp does not own it - the db it is in does. Grant the required privileges
WITH GRANT OPTION to the owner of the sp.