Grant question

Posted in 1998

RVASUDEV — Mon, 9 Nov 1998 11:18:34 +0530 — source: Informix-list mailing list archive (1991-1998)

Hi, A table is owned by a user A. Trying to give update privilege on the table to user B, while logged in as user informix, gave error : 302: No GRANT option or illegal option on multi-table view. Why is this ? Isn't the informix user like root for UNIX, i.e. should be able to give any permission to anyone on any table ? Or is it possible for the owner of a table to revoke privileges from a table even for informix ? Thanks in advance Vasudev