Re: security rights per database DDL/DML connect

From: Dan Langille <dan(at)langille(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, Gabor Faludi <falu(at)fits(dot)hu>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: security rights per database DDL/DML connect
Date: 2002-10-23 04:49:52
Message-ID: 20021023004333.I65358-100000@m20.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 23 Oct 2002, Tom Lane wrote:

> Dan Langille <dan(at)langille(dot)org> writes:
> > Will I be able to give people the right to execute a function, but not
> > view it?
>
> Write it in C. Short of that, you're asking for unenforceable
> restrictions on the ability to read pg_proc.

I like that approach.

Given that the existing functions are written in plpgsql, is there a good
guide to converting to C?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gareth Kirwan 2002-10-23 09:26:59 INT array field referencing same table
Previous Message Tom Lane 2002-10-23 04:40:49 Re: security rights per database DDL/DML connect