Re: user privilege to create c function - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: user privilege to create c function
Date
Msg-id 20050713005005.GE15464@alvh.no-ip.org
Whole thread Raw
In response to user privilege to create c function  ("TJ O'Donnell" <tjo@acm.org>)
List 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)

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: export/import database
Next
From: Michael Fuhr
Date:
Subject: Re: Temp tables...