Re: function privileges - Mailing list pgsql-novice

From Tom Lane
Subject Re: function privileges
Date
Msg-id 22869.1138942628@sss.pgh.pa.us
Whole thread Raw
In response to function privileges  (Murat Tasan <murat.tasan@cwru.edu>)
Responses Re: function privileges
List pgsql-novice
Murat Tasan <murat.tasan@cwru.edu> writes:
> If user A comes along and has no SELECT privileges on T, but has
> EXECUTE privileges on F, A is not permitted to run the function, with
> an error stating access to T is needed.

> Now, if user B comes along and has SELECT privileges on T, but not
> EXECUTE privileges on F, B is permitted to run the function.

I don't think I believe either of the above statements.  Perhaps you
could provide a complete example of what you're doing?

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: function privileges
Next
From: Arnaud Lesauvage
Date:
Subject: schemas in functions