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

No doubt this is simple but I can't see it. The following was all done as the DBA user. The database is SE 7.12 and is NOT mode ANSI. Everything is on one server and in one database - ie simple. 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. Does anyone know why this fails? Help gratefully received. None of the explanations given by finderr seem to apply: -302 No GRANT option or illegal option on multi-table view. This GRANT statement cannot be executed. Either you do not have the right to grant the specified privilege for this table; or else the table name given is a synonym; or the table is in fact a view on which this option cannot be granted. In order to grant any privilege for a table you must either have Database Administrator (DBA) privilege in this database, or you must be the owner of the table, or you must have been granted the same privilege WITH GRANT OPTION. If one of these things is true, then the problem must be that the table in question is really a synonym or a view that is not modifiable, and so cannot be used for insert, update, or delete operations. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/