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(at)fuhr(dot)org>
To: "Tk421" <vrobador(at)vodafone(dot)es>
Cc: <pgsql-general(at)postgresql(dot)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
>