Archives of the TeradataForum
Message Posted: Thu, 08 Jan 2004 @ 20:49:02 GMT
We have built special stored procedure users to compile and maintain stored procedures. You only need to be that user to compile stored procedures using dynamic SQL. By the way, our first journeys into dynamic sql/ddl stored procedures are going extremely well.
Other users (given appropriate permissions) can execute the procedures, so this isn't a very painful limitation.
I plan to use them more frequently, especially to give the application production support teams limited permissions, e.g., allowing them to recollect statistics on a table, but not mess with the indices, the statistics that are collected, etc.
Only issue I have found is with a procedure that grants system users rights on a database, since the Stored Procedure User does not have any access rights to the created database, when I want to run it. Solution, the DBA has to have his own stored procedure.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|