pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Encrypt functions
4+ messages / 3 participants
[nested] [flat]

* Encrypt functions
@ 2020-12-22 14:56 Yambu <hyambu@gmail.com>
  2020-12-22 14:59 ` Re: Encrypt functions hubert depesz lubaczewski <depesz@depesz.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Yambu @ 2020-12-22 14:56 UTC (permalink / raw)
  To: Pgsql-admin <pgsql-admin@lists.postgresql.org>

Hello

Is it possible to prevent users from seeing the code in functions?

regards

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Encrypt functions
  2020-12-22 14:56 Encrypt functions Yambu <hyambu@gmail.com>
@ 2020-12-22 14:59 ` hubert depesz lubaczewski <depesz@depesz.com>
  2020-12-22 15:03   ` Re: Encrypt functions Yambu <hyambu@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: hubert depesz lubaczewski @ 2020-12-22 14:59 UTC (permalink / raw)
  To: Yambu <hyambu@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

On Tue, Dec 22, 2020 at 04:56:40PM +0200, Yambu wrote:
> Is it possible to prevent users from seeing the code in functions?

Sure. Write them in C, and compile.

Best regards,

depesz






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Encrypt functions
  2020-12-22 14:56 Encrypt functions Yambu <hyambu@gmail.com>
  2020-12-22 14:59 ` Re: Encrypt functions hubert depesz lubaczewski <depesz@depesz.com>
@ 2020-12-22 15:03   ` Yambu <hyambu@gmail.com>
  2020-12-22 17:08     ` Re: Encrypt functions Imre Samu <pella.samu@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Yambu @ 2020-12-22 15:03 UTC (permalink / raw)
  To: depesz@depesz.com; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

We have limited time ,we want to use the functions on a new client, there
won't be time to re-write the functions in C. Is there any other way ?

regards

On Tue, Dec 22, 2020 at 4:59 PM hubert depesz lubaczewski <depesz@depesz.com>
wrote:

> On Tue, Dec 22, 2020 at 04:56:40PM +0200, Yambu wrote:
> > Is it possible to prevent users from seeing the code in functions?
>
> Sure. Write them in C, and compile.
>
> Best regards,
>
> depesz
>
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Encrypt functions
  2020-12-22 14:56 Encrypt functions Yambu <hyambu@gmail.com>
  2020-12-22 14:59 ` Re: Encrypt functions hubert depesz lubaczewski <depesz@depesz.com>
  2020-12-22 15:03   ` Re: Encrypt functions Yambu <hyambu@gmail.com>
@ 2020-12-22 17:08     ` Imre Samu <pella.samu@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Imre Samu @ 2020-12-22 17:08 UTC (permalink / raw)
  To: Yambu <hyambu@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

> Is it possible to prevent users from seeing the code in functions?
> We have limited time ,we want to use the functions on a new client, there
won't be time to re-write the functions in C.
> Is there any other way ?

other ideas:
- custom encryption wrapper in C
- or 3rd party encryption :
https://www.cybertec-postgresql.com/en/products/plpgsql_sec-encrypt-source-code/

best regards,
 Imre




Yambu <hyambu@gmail.com> ezt írta (időpont: 2020. dec. 22., K, 16:03):

> We have limited time ,we want to use the functions on a new client, there
> won't be time to re-write the functions in C. Is there any other way ?
>
> regards
>
> On Tue, Dec 22, 2020 at 4:59 PM hubert depesz lubaczewski <
> depesz@depesz.com> wrote:
>
>> On Tue, Dec 22, 2020 at 04:56:40PM +0200, Yambu wrote:
>> > Is it possible to prevent users from seeing the code in functions?
>>
>> Sure. Write them in C, and compile.
>>
>> Best regards,
>>
>> depesz
>>
>>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2020-12-22 17:08 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-22 14:56 Encrypt functions Yambu <hyambu@gmail.com>
2020-12-22 14:59 ` hubert depesz lubaczewski <depesz@depesz.com>
2020-12-22 15:03   ` Yambu <hyambu@gmail.com>
2020-12-22 17:08     ` Imre Samu <pella.samu@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox