From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: Problem with function permission test in a view |
Date: | 2003-09-28 23:11:55 |
Message-ID: | 3F776ABB.9060509@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
> I like your text much better --- added. I will throw this email in the
> 7.5 queue and we can decide if it is a bug then.
If is a bug is better have a patch for the 7.4
May be is only a missing feature.
For sure for us was and is actually a nightmare imagine :
V1 -> V2 -> F
/
V3 -> V4
This mean that if a group A can use the view V1 and
a group B can use a view V3 whe shall back trace that
the function F must be executable by group A due V1
and by group B due V3. Fortunatelly Postgres now take
trace of dependencies so we can ( not easily ) analyze
each function and see if is used inside a view or not,
and choose the right permission.
We have ~ 100 View and ~ 100 functions :-(
Regards
Gaetano Mendola
PS: I vote that is a bug :-)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-09-28 23:43:36 | Re: more i18n/l10n issues |
Previous Message | Peter Eisentraut | 2003-09-28 22:27:01 | Re: more i18n/l10n issues |