Archives of the TeradataForum
Message Posted: Sat, 08 Jan 2005 @ 12:28:29 GMT
<-- 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".
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|