Re: crypting prosrc in pg_proc - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: crypting prosrc in pg_proc
Date
Msg-id 1186742832.6361.5.camel@hannu-laptop
Whole thread Raw
In response to Re: crypting prosrc in pg_proc  (Hans-Juergen Schoenig <postgres@cybertec.at>)
List 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


> 



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: crypting prosrc in pg_proc
Next
From: Omar Bettin
Date:
Subject: Re: communication protocol