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