Re: user privilege to create c function

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: tjo(at)acm(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: user privilege to create c function
Date: 2005-07-12 22:52:58
Message-ID: 42D449CA.3050506@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-07-12 23:48:51 Re: Windows version of PostgreSQL 8.x?
Previous Message Joshua D. Drake 2005-07-12 22:52:21 Re: postgresql SSL off