 |
 |
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.
| |
