Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2008 @ 10:59:56 GMT


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


Subj:   Can TDWM limit grant/revoke access rights
 
From:   Okell, Alan

I suspect the answer is 'no' but does anybody know if it possible to use TDWM to limit users ability to Grant / or Revoke Access Rights. I've checked the doc'n and its not explicitly covered.

On a more general security point, how are other sites handling the 'With Grant Option' users automatically receive when Creating a Table. We have users who have access to sensitive customer data and those who don't, and the goal is to remove the ability of users with access to sensitive data to grant that access to others.

Apart from going in and revoking these 'With Grant option' access rights following each Create table, supported by monitoring and reporting, I'm not sure how else this could be done.

Any ideas ?



     
  <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