Postgres Pro
Downloads
Home   >   mailing lists

Re: Revoking Function Execute Privilege - Mailing list pgsql-general

From Tom Lane
Subject Re: Revoking Function Execute Privilege
Date
Msg-id 26562.1297703842@sss.pgh.pa.us
Whole thread Raw
In response to Revoking Function Execute Privilege  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
Tree view 
"David Johnston" <polobo@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

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Revoking Function Execute Privilege
Next
From: Ahmed Ossama
Date:
Subject: Using Bitmap scan instead of Seq scan