Why security-definer functions are executable by public by default? - Mailing list pgsql-general

hi

was pointed to the fact that security definer functions have the same
default privileges as normal functions in the same language - i.e. if
the language is trusted - public has the right to execute them.

maybe i'm missing something important, but given the fact that security
definer functions are used to get access to things that you usually
don't have access to - shouldn't the privilege be revoked by default,
and grants left for dba to decide?

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: postgres segfaulting on pg_restore
Next
From: Sim Zacks
Date:
Subject: Re: Why security-definer functions are executable by public by default?