Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 08 Jan 2004 @ 20:49:02 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Rights required to create a Stored Procedure
From:   Glen Blood


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.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020