Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2004 @ 15:49:01 GMT


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


Subj:   Re: Stored procedure permissions
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, June 30, 2004 11:45 -->

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.



     
  <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: 23 Jun 2019