Could Not Execute Query Error Permission Denied For Language C
Contents |
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists
Redshift Permission Denied For Language Plpythonu
Regional lists Associations User groups Project lists Inactive rds superuser lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News grant superuser postgres Re: ERROR: permission denied for language c From: "Shahryar G(dot) Hashemi"
Postgres Make User Superuser
c Date: 2007-01-09 04:26:53 Message-ID: 8459AE1CDB7A0441A1ED87C375891E4602F6D9D4@EXCHIS5BV.inspinc.ad (view raw or whole thread) Thread: 2007-01-09 04:26:53 from "Shahryar G(dot) Hashemi"
Redshift Functions
January 08, 2007 8:19 PM To: 'pgsql-admin(at)postgresql(dot)org' Subject: ERROR: permission denied for language c Hi, I have created a new user called hydra with 'createdb' permission. I can create the DB but when I run this command I get this error. I did the GRANT USAGE for LANGUAGE C to hydra. But still the error. Any ideas? hydra=> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler hydra-> AS '$libdir/plpgsql', 'plpgsql_call_handler' hydra-> LANGUAGE c; ERROR: permission denied for language c I maybe doing something wrong. Does the user need to be created differently? I am using pg_restore to restore a DB image. Shahryar -- Shahryar G. Hashemi DBA InfoSpace Inc. 601 108th Ave NE Suite 1200 Bellevue, WA 98004 U.S.A. Office: +1 425.201.8853 Fax: +1 425.201.6160 Alpha Pager: page-shashem(at)infospace(dot)com Num
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations pg_restore User groups Project lists Inactive lists IRC Local User
Pg_dump
Groups Featured Users International Sites Propaganda Resources Weekly News Re: Backup & Restore a database in PostgreSQL From: Siva Palanisamy
O'Donnell Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ user privilege to create c function Until now I have been content to have the http://postgresql.nabble.com/user-privilege-to-create-c-function-td1846063.html 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 ---------------------------(end permission denied of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings Joshua D. Drake Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: user privilege to create c function 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: > permission denied for > 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 Álvaro Herrera Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: user privilege to create c function In reply to this post by TJ O'Donnell 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