Re: Functions in postgres

    I want to hide the code itself

Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com
----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Tk421" <vrobador@vodafone.es>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, November 09, 2004 4:11 PM
Subject: Re: [GENERAL] Functions in postgres


> On Tue, Nov 09, 2004 at 01:29:19PM +0100, Tk421 wrote:
>
> > I've made some functions, an i want these functions to be used
> > by a specified user, but i don't want this user can see the code
> > of the functions.
>
> Are you trying to hide the code itself, or are you just trying to
> hide sensitive data embedded in the code?  If the latter, then you
> might be able to move the data to a table and create the function
> with SECURITY DEFINER.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>