Alan McDonald wrote:

>>> GRANT and REVOKE is DML not DDL so it's not a problem.
>> Nope. DML is INSERT, UPDATE, DELETE and SELECT.
>>
>> GRANT and REVOKE are DDL - they cause objects to be created and
>> destroyed.
>>
> what objects?

GRANT objects.

> Isn't this DML?

You don't modify user data, but metadata in system tables. Ergo, it is DDL.


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com