Re: allowing users access to a trusted C function

From: Jeff Davis <jdavis(at)wasabimg(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: allowing users access to a trusted C function
Date: 2000-12-23 13:27:40
Message-ID: 3A44A84B.D191FC1D@wasabimg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> Jeff Davis <jdavis(at)wasabimg(dot)com> writes:
> > I created (as a superuser) a set of C functions to handle boolean
> > arithmetic (has to do with simplifying search queries of mine). I would
> > like users to be able to access those functions somehow.
>
> If the functions are listed in pg_proc, anyone can call them.
>
> regards, tom lane

I should have mentioned this, but all my users have their own DB. I have
entries for the functions in pg_proc for template1 and postgres (DB of my
superuser), but they won't be recognized in other DBs.

Thanks,
Jeff Davis

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-12-23 14:23:49 Re: Database I/O and other performance questions.
Previous Message Lincoln Yeoh 2000-12-23 10:14:26 Database I/O and other performance questions.