It would seem that trying to hide code while using
an open source system is just wrong. 8-)
That being said -- You would grant the
user/group execute rights on the function, but no read rights on the system
table that contains the function definition, pg_proc.
How is this user supposed to
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
&g
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 embe
Am Dienstag, 9. November 2004 13:29 schrieb Tk421:
> 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. Does somebody knows how can i do this?
The only way to do that would be to write the functi
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. Does somebody knows how can i do
this?
Sorry about my english, i'm
spanish.
Víctor Robador Capel
Análisis de Sistemas y Programación
On Thu, Apr 06, 2000 at 04:48:02PM -0500, Jeff Gerhart wrote:
> Ross,
> Thats for the input. Have a couple of additional questions:
>
> 1- I have the code running and it appears that I get a different result each
> time I sqlcrypt the same string e.g. select sqlcrypt('xyz') gives me a
> different
On Wed, Apr 05, 2000 at 12:04:49PM -0500, Victor Manuel Jaquez Leal wrote:
>
> Hi!
Hi back at ya.
>
> I know that with \df you can see the functions available in postgres, but
> there must be others not documented just like getpgusername().
>
> My question is if are there a more complete list
Ah, I forget to mention how to compile the code I sent. I use:
gcc -fPIC -shared -I /usr/local/pgsql/include -L /usr/local/pgsql/lib
-o sqlcrypt.so sqlcrypt.c
then move the sqlcrypt.so file into my pgsql storage space. This is
on Linux, if it matters.
Ross
--
Ross J. Reedstrom, Ph.D., <[E
Hi!
I know that with \df you can see the functions available in postgres, but
there must be others not documented just like getpgusername().
My question is if are there a more complete list of postgres'
functions. To be more specific I'm looking for a crypt function.
BTW
How do I implement a