Martijn Tonies wrote:

> Because GRANT/REVOKE is a DDL command. DDL commands
> cannot be used in stored procedures or triggers.

Yes, I already know that my wishes was excessive :)

> If you really really need to use those command, have a look at the
> Release Notes and search for EXECUTE STATEMENT.

Great thanks Martijn, it works fine

--
Best regards,
Eugene Voytitsky