Execute function without execute privilege - Mailing list pgsql-novice

From Walker, Jed S
Subject Execute function without execute privilege
Date
Msg-id 41669DC6FE3B80449A33A4DD46DB370A0D1EE6F6@entcoexch15.broadband.att.com
Whole thread Raw
Responses Re: Execute function without execute privilege  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice

I discovered today that when I create a function in a schema that another user has "grant usage" on, they are able to execute the function even though I've not granted them "execute" on the function.

Is this normal behavior (from the manual I don't believe it is)?

If so, is the best solution to put all of our functions into separate schemas and grant usage on those based on what groups of functions someone needs?

Thanks!

      Jed S. Walker

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Re: date interval
Next
From: Tom Lane
Date:
Subject: Re: Execute function without execute privilege