Re: Grant question

Hi Vasu ! I have dropped u a mail in detail. Anyway, did u try the option " as user ". The sql should like this : grant update on temp_table to B as A where, temp_table is the table created by user A. Sameer In article <726a2k$phn$1@news.xmission.com>, RVASUDEV <RVASUDEV@inf.com> 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 ? > > Thanks in advance > > Vasudev > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own