I'm at a loss with configuring the IRIS ODBC driver (v02.10) on my Amazon Linux machine, connecting to a REMOTE IRIS backend. It should be simplified by not requiring a DSN (the app uses a DSN-less connection and generates the connection string). I have
Trying to identify which records in the %SYS.Audit table are fails.
Eg, as user "WORKER", I run an attempted a grant, the terminal returns:
SQL> GRANT SELECT ON newschema.patients TO COORDINATOR [S1000][Iris ODBC][State : S1000][Native Code 112] [libirisodbc35.so] [SQLCODE: <-112>:<Access violation>] [Location: <ServerLoop>] [%msg: <User WORKER does not have required privileges to grant the privilege(s)>] [ISQL]ERROR: Could not SQLExecute