Re: alter view or something

On 15 Jun, 17:45, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Jun 15, 10:55 am, b <b...@bb.hr> wrote: > > > So, we have views and on top them we have private synonyms. Users get > > permissions on private synonyms which are in fact views. > > From time to time data structure is changed so we recreate (drop/create) > > views. Unfortunatly that means that permissions are also dropped. Is there > > any way to avoid this? My idea is to have something like "alter(or modify) > > view", but as far as I know there isn't such thing. Any ideas? > > Ifx 10UC6 > > Nothing like ALTER VIEW... You're just going to have to remember to > reinstate the privs. > > Art S. Kagel How about <GASP> raise a Feeature Request? No wonder this stuff isn't there if no one asks IBM for it. David.