Re: crypting prosrc in pg_proc

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: crypting prosrc in pg_proc
Date: 2007-08-10 09:01:24
Message-ID: 1186736484.6361.3.camel@hannu-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ühel kenal päeval, N, 2007-08-09 kell 16:42, kirjutas Hans-Juergen
Schoenig:

>
>
> well, the complete analysis is easy - the solution is not.
> currently we have basically no option to reduce access to the system
> tables. this would be hard anyway as we need those tables for
> basically all kinds of operations.
> the problem here is that vendors of appliances don't want people to
> spider their codes. this is a fact - it is not the idea of open source
> to do so but bloody reality. in addition to that people are not
> willing to code everything in C just to hide.

Maybe you can write PL/PgSQL compiler, just compiling to C would be
enough.

And it would be generally useful.

> so, there has to be a concept to achieve this for stored procedures
> somehow.
> i am afraid the source level encryption is the easiest thing and most
> understandable thing to do.

make it just rot13 then. will be asy to break anyhow ;)

--------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2007-08-10 10:47:12 Re: crypting prosrc in pg_proc
Previous Message Tommy Gildseth 2007-08-10 06:12:38 Re: Internal Postgre SQL documentation