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

Vinay,

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.


Regards,

Alan



     
  <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