Bug (?) issuing Grant statement thru Informix CLI 2.8.0005 ODBC driver (from 7.3TC7)

Posted in 1999

Fuzzy — Fri, 07 May 1999 06:06:47 GMT — source: Informix-list mailing list archive (1991-1998)

Hi all, Here's my problem. When I issue the following thru the Informix CLI 2.80.0005 ODBC driver (from 7.3TC7), grant select, insert, update, delete on mytable to myrole It barfs with the following error ERROR state: 37000(-11060) Error: [Informix][Odbc Informix Driver]General error. Syntax error Now, it doesn't happen through SQL Editor, and it doesn't happen with the CLI 2.5 ODBC driver. I've checked the table exists, the role exists, and the user has DBA privileges - infact they can create tables happily. Can anyone confirm this bug, or tell me what I'm doing wrong? Ciao Fuzzy :-)