Error on GRANT SELECT in a View with Union

Hello All, Thank you in advance. I am trying to create a View, which contains a UNION statement, and I am receiving error "302: No GRANT option or illegal option on multi-table view. " It creates the view, does the REVOKE ALL then errors on the GRANT SELECT statement. Can you not GRANT SELECT on a VIEW that has a UNION and if not then how do you grant? Thanks

add an AS-clause and check that the sysauthtab contains what you expect it to contain. Nona >Subject: Error on GRANT SELECT in a View with Union >From: "Gail" wormang@sutterhealth.org >Date: 11.04.00 17:33 W. Europe Daylight Time >Message-id: <01bfa3cb$48785f00$f5c4abd0@cm083218.sutterhealth.org> > >Hello All, >Thank you in advance. I am trying to create a View, which contains a UNION >statement, and I am receiving error "302: No GRANT option or illegal option >on multi-table view. " It creates the view, does the REVOKE ALL then errors >on the GRANT SELECT statement. Can you not GRANT SELECT on a VIEW that has >a UNION and if not then how do you grant? > >Thanks >