Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2007 @ 18:16:05 GMT


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


Subj:   Re: Segregation of Duties - Security and DBA
 
From:   Vinay Bagare

Alan,

Yes, the current stored procedure could have grants to role. Again the stored procedure in question can be parameterized to pass the role name.

A dynamic SQL can easily be constructed and granted. As the SP is created by DBA (so is the role), you don't have to worry about the WITH grant option.

You would just need to grant an execute procedure call to the security administrator.

I have used this approach in past with great success and I am trying to build a UI (simple Excel based). I wish I had some .Net expertise!


HTH

Thanks,

Vinay Bagare



     
  <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: 15 Jun 2023