 |
 |
Archives of the TeradataForum
Message Posted: Fri, 11 Oct 2003 @ 02:16:25 GMT
| Subj: | | Re: Stored procedure rights |
| |
| From: | | Christie, Jon |
The owner of the stored procedure needs to have the rights to do whatever the stored procedure does and it needs those rights with
the grant option. The user that calls the stored procedure only needs to have the execute right on the stored procedure.
A note about "owner" above. Generally, the owner is the database or user within which the stored procedure resides, but it could
also be any user/database higher up in the ownership chain.
| |
