Re: protecting prosrc (was Re: [GENERAL] USAGE on schema - Mailing list pgsql-hackers

From Joe Conway
Subject Re: protecting prosrc (was Re: [GENERAL] USAGE on schema
Date
Msg-id 3DEBD0E5.1070109@joeconway.com
Whole thread Raw
In response to Re: protecting prosrc (was Re: [GENERAL] USAGE on schema allowed by  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne wrote:
>>I think this would be a good idea, though there becomes a question of
>>what type of performance hit comes into play when doing this. I suppose
>>if you have an option whether to encrypt it or not that would help.  One
>>other thing is that it needs to be "decryptable" by owners and
>>superusers.
> 
> Surely a more generic column privileges implementation would be better?

I think column privileges is orthogonal to this issue. The ability to 
"protect" stored procedure or package source is common among at least the 
commercial databases I've worked with (as is column level grants).

Joe



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: protecting prosrc (was Re: [GENERAL] USAGE on schema
Next
From: Stephan Szabo
Date:
Subject: Re: 7.4 Wishlist