Archives of the TeradataForum
Message Posted: Fri, 22 Feb 2008 @ 23:32:42 GMT
| Subj: || || Re: Stored Procedure error SPL1031 |
| From: || || Victor Sokovin |
| ||I agree that REVOKE FROM sounds better in English. But believe it or not, in Teradata "REVOKE" syntax the keywords "FROM" and "TO" are
interchangeable. ("GRANT" only accepts "TO".)|| |
I stand corrected. REVOKE ... FROM is ANSI compliant; REVOKE ... TO is a Teradata extension. Perhaps a useful one, when you think of it. A
GRANT script can be converted to a REVOKE script by replacing one word. Saves some effort.