Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 09 Jan 2005 @ 17:43:02 GMT


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


Subj:   Re: Why are Revoke Statements passive
 
From:   Fred Pluebell

If you want to know if REVOKE actually removed any access rights, you can check the ActivityCount. Some other databases do return an error if you attempt to REVOKE a right the user does not currently hold, but in my experience that is at best unimportant and often just a nuisance the DBA must deal with. I can't recall encountering any database that considers it an error to attempt to GRANT rights the user already holds...

GRANT should never remove any access (e.g. GRANT OPTION); to do so would be semantically incorrect.



     
  <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