title: How postgresql give permission what execute a function in schema to user
body: <p>I have a function named <code>schema.func</code>, I want to give a permission what execute <code>schema.func</code> to the user.</p>
  
  <p>I try to use</p>
  
  <pre><code>GRANT EXECUTE ON schema.func to my_user;
  </code></pre>
  
  <p>but it is not working. When I perform this function it throws the error:  </p>
  
  <blockquote>
    <p>permission denied for schema ex</p>
  </blockquote>
  
  <p>I know I can use <code>GRANT USAGE ON SCHEMA</code>, but this is not what I want, I just need permissions for specific functions, not all functions in the schema.</p>
  
  <p>Can I do that?</p>