| From: | Hannu Krosing <hannu(at)skype(dot)net> |
|---|---|
| To: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> |
| Cc: | "korry(dot)douglas" <korry(dot)douglas(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: crypting prosrc in pg_proc |
| Date: | 2007-08-10 10:47:12 |
| Message-ID: | 1186742832.6361.5.camel@hannu-laptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Ühel kenal päeval, N, 2007-08-09 kell 16:54, kirjutas Hans-Juergen
Schoenig:
> >
> > Of course, if your goal is to hide the code from someone snooping
> > through the pg_proc relation (on disk), then encryption will
> > certainly help (provided the key is properly protected).
> >
> >
>
>
>
>
> no, somebody who has access to the filesystem is not relevant.
> just think of shipping some database inside some router or inside some
> other stuff. the vendor just wants to make sure that other people
> don't fully understand the "magic" going on.
Just access everything through functions and REVOKE all right except
EXECUTE from user.
------------
Hannu
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Omar Bettin | 2007-08-10 11:10:32 | Re: communication protocol |
| Previous Message | Hannu Krosing | 2007-08-10 09:01:24 | Re: crypting prosrc in pg_proc |