How to Revoke Execute Privileges on Functions in PostgreSQL by Default
<p>I am trying to set up default privileges in PostgreSQL 9.5.4 using the command <code>ALTER DEFAULT PRIVILEGES...</code>.  This works when trying to grant permissions, but I can't figure out how to revoke execute permissions from functions by default.  I have tried:</p>

<pre><code>ALTER DEFAULT PRIVILEGES FOR USER myAdmin IN SCHEMA public
    REVOKE EXECUTE ON FUNCTIONS FROM public;
</code></pre>

<p>This appears to have no effect on the output of <code>\ddp</code>.  Is there a way to prevent functions from being executable by users other than the owner, unless otherwise granted?  Thanks.</p>