Re: masking the code

hello

2009/6/26  <luca.ciciriello@email.it>:
> I've wrote a PLPGSQL stored procedure for a DB I've to delivery to my
> customer. The problem is that I want to hide the code of the stored
> procedure. I don't want that my customer is able to read the code of the my
> sp.
>
> Do exist a way to mask the code of the store procedure shipped with my DB?
>

no - PostgreSQL doesn't support any form of obfuscation PL code. If
you have superuser rights on database - and your customer not, then
you can REVOKE SELECT right from pg_proc table.

regards
Pavel Stehule



> Thanks in advance.
>
> Luca.
>  --
>  Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
> autenticato? GRATIS solo con Email.it: http://www.email.it/f
>
>  Sponsor:
>  GRATIS: 250 Biglietti da Visita + 1 elegante Porta biglietti metallico!
> Spese di spedizione escluse. Offerta limitata, fai in fretta!
>  Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8956&d=20090626
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>