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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend