Utility of GRANT EXECUTE - Mailing list pgsql-general

From Paul Mackay
Subject Utility of GRANT EXECUTE
Date
Msg-id 786c2f6d0603140024l16824e6dm6cf37f2ca0570ca5@mail.gmail.com
Whole thread Raw
Responses Re: Utility of GRANT EXECUTE  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
It seems that any user has the right to execute a function, whether or not it has been granted the EXECUTE privilege on it. Even a REVOKE EXECUTE has no impact. A privilige error will be raised only if the function tries to access an object (ex.: a table) for witch the user doesn't have the appropriate privilege(s).

Is there any utility to the GRANT EXECUTE then ?


Thanks,
Paul

pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Re: Update value to "the first character is capital and
Next
From: Michael Fuhr
Date:
Subject: Re: Utility of GRANT EXECUTE