Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Jul 2004 @ 16:30:40 GMT


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


Subj:   Access to Stored Procedures
 
From:   David Clough

Someone wrote recently:

  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.  


Fair enough. I seem to remember, however, that MACRO privilege was different to Stored Procedure privilege. Can someone re-fresh my memory on what that difference was please?


Dave Clough
Database Designer
Database Design Group



     
  <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