Postgres Pro
Downloads
Home   >   mailing lists

Re: Restrict permissions on schema to hide pl/pgsql code - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Restrict permissions on schema to hide pl/pgsql code
Date
Msg-id CAKFQuwasburx+UXm9Do9CFVRKFtET=US2zrYnrJcGW9aob5xrg@mail.gmail.com
Whole thread Raw
In response to Restrict permissions on schema to hide pl/pgsql code  (Swanand Kshirsagar <swanandon@gmail.com>)
Responses Re: Restrict permissions on schema to hide pl/pgsql code
List pgsql-admin
Tree view
On Wednesday, July 24, 2019, Swanand Kshirsagar <swanandon@gmail.com> wrote:
Isn't revoking permissions from a schema should take care of this situation?

The pl/pgsql function body is stored in pg_catalog which the user still has permission to read.  There isn’t a good/supported way to work around this behavior.

David J.


pgsql-admin by date:

Previous
From: Swanand Kshirsagar
Date:
Subject: Restrict permissions on schema to hide pl/pgsql code
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_locks relation cant be found in pg_class