Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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

Yes.

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.


Glen



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