Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2007 @ 10:07:09 GMT

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

Subj:   Re: Segregation of Duties - Security and DBA
From:   Okell, Alan


Many thanks for this although if you wouldn't mind, I could do with a couple of points clarifying.

When you say you assume Roles for administrating the Grants have been created, do you just mean that they are in place, as I don't think you can use Roles to administer Grants (no 'With Grant Option' permitted) ?

Also, not sure how your stored procedure would work - are you saying the Stored Procedure includes making Grants to the Security Administrators, prior to granting the required access to a Role (presumably this is the part passed in parameters), or that only the execute stored procedure privilege would be required.



  <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