"David Johnston" <polobo@xxxxxxxxx> writes: > REVOKE ALL ON FUNCTION testfunc() FROM impotent; This does not get rid of the default public execute permissions on the function. To limit execute rights, you first have to REVOKE ALL ON FUNCTION testfunc() FROM PUBLIC; and then grant rights back to the appropriate subset of users. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general