Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 09 Jan 2005 @ 09:50:24 GMT

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

Subj:   Re: Why are Revoke Statements passive
From:   Victor Sokovin

  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?  

I'm afraid I don't know what the rational was. It might be worth comparing this with the ANSI recommendations but I cannot look them up right now. However, I did quickly check this on Oracle, and Oracle does issue an error in this case.

  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".  

For what that might be worth, Oracle is doing the same. Again, I don't know off-hand whether this is in line with the ANSI recommendations. I'll try to look them up but it might take some time before I can get hold of them.



  <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