Re: user privilege to create c function

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: TJ O'Donnell <tjo(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: user privilege to create c function
Date: 2005-07-13 00:50:05
Message-ID: 20050713005005.GE15464@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 12, 2005 at 03:43:43PM -0700, TJ O'Donnell wrote:
> Until now I have been content to have the superuser CREATE FUNCTION...LANGUAGE 'C'
> because I noticed that ordinary users could not:
>
> ERROR: permission denied for language c
>
> I would like to allow a user to create C language functions, but can't
> find just which privilege I need to grant. The user owns the
> database, by the way, but still can't create the function. The user only
> needs to create C functions for her own database(s).

Any user with access to writing C functions can do anything, not
limited to his own database.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-07-13 00:57:00 Re: Temp tables...
Previous Message Michael Fuhr 2005-07-13 00:11:23 Re: export/import database