title: How to Revoke Execute Privileges on Functions in PostgreSQL by Default
body: <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>