Re: BUG #14103: stored function encryption

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14103: stored function encryption
Date: 2016-04-30 06:27:55
Message-ID: 409f9f72-6e17-55e2-2de0-53ca6b069e8f@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 4/29/2016 7:01 PM, Bruce Momjian wrote:
>>> how to encrypt functions in Postgresql so that we can hide all my business
>>> > >logic ?
>> >
>> >write them in C or another compiled language, supply them as .SO (or .dll)
>> >files.
> FYI, you can often run 'strings' on the object file to see the SQL
> queries.

hah, true, so I guess if you really want to hide it, you've got to hash
all your string constants, or use an obtuse sql generator.

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2016-04-30 23:01:00 Re: BUG #14103: stored function encryption
Previous Message Bruce Momjian 2016-04-30 02:01:30 Re: BUG #14103: stored function encryption