 |
 |
Archives of the TeradataForum
Message Posted: Wed, 07 Jul 2004 @ 16:30:40 GMT
| Subj: | | Access to Stored Procedures |
| |
| From: | | David Clough |
Someone wrote recently:
| | 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. | |
Fair enough. I seem to remember, however, that MACRO privilege was different to Stored Procedure privilege. Can someone re-fresh my memory on
what that difference was please?
Dave Clough
Database Designer
Database Design Group
| |
