Re: Grant question

RVASUDEV wrote: > > 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 ? Just leave out the 'AS userA' clause and this will work fine. Don't as me why the 'AS user' syntax does not work, it used to. Art S. Kagel