Re: Problem with function permission test in a view - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with function permission test in a view
Date
Msg-id 28477.1063299767@sss.pgh.pa.us
Whole thread Raw
In response to Problem with function permission test in a view  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Problem with function permission test in a view  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Someone asked me a question about view and function permissions.  I
> assumed all object access done by a view would be based on the
> permissions on the view, and not the permissions of the objects.

Table references are checked according to the owner of the view, but use
in a view does not change the execution context for function or operator
calls.  This is how it's always been done.

> Is this a bug?

Changing it would be a major definitional change (and a pretty major
implementation change too).  It might be better, but please don't
pre-judge the issue by labeling it a bug.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: massive quotes?
Next
From: Andreas Pflug
Date:
Subject: Re: massive quotes?