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