|
Archives of the TeradataForumMessage Posted: Wed, 03 Aug 2005 @ 19:11:05 GMT
Srikanth, I may be wrong. But I believe the dynamic sql restriction is misunderstood. I believe it works in this situation. Create a User and name it something like PROD_PROCS. Then create the stored procedures in PROD_PROCS. It does not matter who creates the stored procs. Then you can use any user to CALL. Proper permission must be given to the calling User and PROD_PROCS user. The calling user just needs Execute procedure on PROD_PROCS. The user PROD_PROCS needs nay access needed by the stored procedures with the grant option. For example, the stored procedure does select, insert, update and delete on database PROD_Tables. The grant would be GRANT select, insert, update, delete on PROD_TABLES to PROD_PROCS with grant option. You never need to logon as PROD_PROCS. This setup has worked fine for us here and have not found any restrictions yet. It also has an advantage for making backups of objects easier. Again if someone knows better, please let me know. Thanks, Bob Diehl
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||