Archives of the TeradataForum
Message Posted: Sun, 09 Jan 2005 @ 09:50:24 GMT
| 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.