PostgreSQL › PostgreSQL - admin

Encrypt functions

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

4 messages Options

Yambu

Encrypt functions

Hello

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

regards

hubert depesz lubaczewski-2

Re: Encrypt functions

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

Yambu

Re: Encrypt 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 ?

regards

On Tue, Dec 22, 2020 at 4:59 PM hubert depesz lubaczewski <[hidden email]> 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

Imre Samu

Re: Encrypt functions

> 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 <[hidden email]> 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 <[hidden email]> 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