Re: ESQL/C and Grant or Revoke statment

Rainer Nasch (nasch@informatik.uni-osnabrueck.de) wrote: : EXEC SQL REVOKE ALL ON iso FROM :user; : where user is a declared ESQL-variable returns an error from the : preprocessor: The REVOKE statement does not accept variables for user. Try this $char string1[200]; sprintf (string1, "revoke all on customer from %s;", user); $PREPARE stmt1 FROM $string1; $EXECUTE stmt1; June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: unknown ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.