user privilege to create c function

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).

Only super users can create c functions, and for very - very good reason.

Sincerely,

Joshua D. Drake

TJ

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

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)