Re: Error -302: No GRANT option or illegal option on multi-table view.

Peter Lancashire <Peter.Lancashire.PL1@bayer.co.uk> offerred: +No doubt this is simple but I can't see it. + +The following was all done as the DBA user. .... +I granted privileges on all tables in the database like this: +grant select on <all_tables> to query with grant option; + +Then I created a view for user "query" as below. The view includes +several tables and an expression. The view works OK. +create view query.ptreatments (...) as select ...; + +Then I attempted this and it failed: +grant select on query.ptreatments to ukkiy; +# ^ +# 302: No GRANT option or illegal option on multi-table view. +# + +User ukkiy has select privilege on all the tables used by the view, +although I do not think that is relevant. You, even as DBA, do not have GRANT privs on the view - you gave them away when you created the view as owned by user query. Run the GRANT as user query, and it should work ok. While you are at it, as user query GRANT ALL ON ptreatments TO DBA; Dave ** Dave Kosenk <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training