Обсуждение: user privilege to create c function
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
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)