Re: ESQL/C and Grant or Revoke statment

Posted in 1997

Michel Behna — Mon, 22 Sep 1997 21:04:06 -0400 — source: Informix-list mailing list archive (1991-1998)

In article <3426ADBB.1EF1F3CA@informatik.uni-osnabrueck.de>, nasch@informatik.uni-osnabrueck.de says... > Hi there, > > when I want to grant or rovoke a permission via an esql/c-program, I can't pass > the > username to the statement. For example: > > EXEC SQL REVOKE ALL ON iso FROM :user; > > where user is a declared ESQL-variable returns an error from the > preprocessor: > > esqlc: "grant.ec", line 27: Error -33051: Syntax error on identifier or symbol > ':'. > > Any idea? > > Please cc-me Your answer! > > Thanks a lot! > > Rainer Nasch > > ---------------------------------------------------------- > Rainer Nasch > Universitaet Osnabrueck Tel: +49 541 969 2487 > FB Mathematik / Informatik Fax: +49 541 969 2770 > 49069 Osnabrueck email: nasch@uni-osnabrueck.de > ---------------------------------------------------------- > > > I am taking a stab in the dark here but I believe that "user" is a reserved keyword. :-) -- Michel Behna DoD #1821