Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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!



Vinay Bagare

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