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

From Joshua D. Drake
Subject Re: user privilege to create c function
Date
Msg-id 42D449CA.3050506@commandprompt.com
Whole thread Raw
In response to user privilege to create c function  ("TJ O'Donnell" <tjo@acm.org>)
List 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/

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: postgresql SSL off
Next
From: John DeSoi
Date:
Subject: Re: Windows version of PostgreSQL 8.x?