Archives of the TeradataForum

Message Posted: Sun, 09 Jan 2005 @ 17:43:02 GMT

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

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.

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