Re: [GENERAL] Functions in postgres

2004-11-13 Thread Sim Zacks
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

Re: [GENERAL] Functions in postgres

2004-11-09 Thread Tk421
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

Re: [GENERAL] Functions in postgres

2004-11-09 Thread Michael Fuhr
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

Re: [GENERAL] Functions in postgres

2004-11-09 Thread Peter Eisentraut
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

[GENERAL] Functions in postgres

2004-11-09 Thread 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?       Sorry about my english, i'm spanish. Víctor Robador Capel   Análisis de Sistemas y Programación  

Re: [GENERAL] Functions in postgres

2000-04-06 Thread Ross J. Reedstrom
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

Re: [GENERAL] Functions in postgres

2000-04-05 Thread Ross J. Reedstrom
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

Re: [GENERAL] Functions in postgres

2000-04-05 Thread Ross J. Reedstrom
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

[GENERAL] Functions in postgres

2000-04-05 Thread Victor Manuel Jaquez Leal
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