Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 08 Jan 2005 @ 12:28:29 GMT


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


Subj:   Why are Revoke Statements passive
 
From:   Anomy Anom

<-- Anonymously Posted: Saturday, January 08, 2005 07:13 -->

The revoke statements are passive. In case Database A didn't have any access over B and you executed revoke select access of A on B it doesn't provide any error message. Can any one please explain what was the rational behind this standard? Can the same be explained for Grant too as below?

In case A had access "GRANT SELECT ON A To B with GRANT OPTION" it doesn't remove the grant authority on executing "GRANT SELECT on A TO B".


Thanks.



     
  <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