"David Johnston" <pol...@yahoo.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general