Re: Functions in postgres - Mailing list pgsql-general

From Tk421
Subject Re: Functions in postgres
Date
Msg-id 001501c4c682$2f7680c0$64005f0a@creativosdolmen.com
Whole thread Raw
In response to Functions in postgres  ("Tk421" <vrobador@vodafone.es>)
List pgsql-general
    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
>



pgsql-general by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: INTERVAL in a function
Next
From: Tom Lane
Date:
Subject: Re: troubleshooting deadlocks