Archives of the TeradataForum
Message Posted: Sat, 08 Jan 2005 @ 12:28:29 GMT
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.
|