alter view or something

Posted in 2007

b — Fri, 15 Jun 2007 16:55:59 +0200 — source: Usenet: comp.databases.informix

So, we have views and on top them we have private synonyms. Users get permissions on private synonyms which are in fact views.

↪ replying to b

Art S. Kagel — Fri, 15 Jun 2007 16:45:48 -0000 — source: Usenet: comp.databases.informix

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

↪ replying to Art S. Kagel

Claus Samuelsen — Sun, 17 Jun 2007 12:41:22 +0200 — source: Usenet: comp.databases.informix

Art S. Kagel 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 > Consider implement ROLEs for easier administration