Grant of "ON COMMIT REFRESH" shows up as syntax error

Howdy,

Yes, I know the beta’s closed, but if I don’t get this out now, I’ll forgets.

In the Editor, this valid statement:

GRANT ON COMMIT REFRESH ON myschema.mytable TO myuser;

…shows up with a syntax error, probably due to the poorly worded “ON COMMIT REFRESH” grantable.

I’ll logoff and wait for someone to tell me I’m full of beans. Hey, I’m full of something, so it might as well be beans.

TY!

Rich

Hi Rich,

If this is a valid statement (and I have no doubt about that) then it is a bug in the syntax checker. I’ll have that fixed asap.

Thanks,

Andre

For completeness, this was fixed in QP5.dll version 5.254, released on Jul 22.