Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?

From: Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?
Date: 2025-05-18 19:17:13
Message-ID: CACX+KaOyuhOf6qcA1jj2AMAhwt_ofXHU2nqE31SmJ+-0qVhU1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Postgres Community,
I had a quick question regarding function-level privileges in PostgreSQL.
We know that REVOKE EXECUTE ON FUNCTION ... removes the ability to call the
function. But when we do:
REVOKE ALL ON FUNCTION my_func(args) FROM some_role;

does this revoke anything other than EXECUTE? Are there any other
privileges that apply to functions which get revoked via REVOKE ALL?

I looked through the documentation but couldn’t find a definitive answer on
whether ALL includes more than just EXECUTE in the context of functions.

Would appreciate any insights or pointers.

---------------
Regards,
Ayush

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jevon Cowell 2025-05-18 19:20:07 pg_stat_statements has duplicate entries for the same query & queryId
Previous Message Achilleas Mantzios 2025-05-16 19:33:29 Re: Logical replication, need to reclaim big disk space