protecting prosrc (was Re: USAGE on schema allowed by default?) - Mailing list pgsql-general

From Joe Conway
Subject protecting prosrc (was Re: USAGE on schema allowed by default?)
Date
Msg-id 3DEB9D4B.7090607@joeconway.com
Whole thread Raw
In response to Re: USAGE on schema allowed by default?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> For example, something I've heard repeatedly is that people would like to
> hide the source code of their SQL or PLxxx functions from users who are
> nonetheless allowed to call those functions.  A row-wise selective view of
> pg_proc can't fix that.  In many cases it's less than clear which rows of
> which catalogs to hide anyway.

It wouldn't be terribly difficult to encrypt prosrc with 3des (or maybe aes)
using the owner's passwd from pg_shadow. We would need a new bool column in
pg_proc (proisencrypted?) and some logic in fmgr.c.

Is there sufficient interest to justify the effort?

Joe


pgsql-general by date:

Previous
From: "Alejandro Michelin Salomon ( Adinet )"
Date:
Subject: PostgreSql on windows
Next
From: Uroš Gruber
Date:
Subject: deny list databases