Postgres Pro
Downloads
Home   >   mailing lists

Thread: user privilege to create c function

user privilege to create c function

From
"TJ O'Donnell"
Date:
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).

TJ

Re: user privilege to create c function

From
"Joshua D. Drake"
Date:
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/

Re: user privilege to create c function

From
Alvaro Herrera
Date:
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)