Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e6M63Ih85611 for ; Sat, 22 Jul 2000 02:03:18 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id CAA04585; Sat, 22 Jul 2000 02:03:09 -0400 (EDT) To: markus.wagner@bigfoot.com cc: pgsql-sql Subject: Re: create function - user permissions In-reply-to: <3978E056.CF082AF7@mail.uni-mainz.de> References: <3978E056.CF082AF7@mail.uni-mainz.de> Comments: In-reply-to Markus Wagner message dated "Sat, 22 Jul 2000 01:44:22 +0200" Date: Sat, 22 Jul 2000 02:03:08 -0400 Message-ID: <4582.964245788@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200007/220 Markus Wagner writes: > one of my users wants to create functions using the C language, but pgs > says "no permission". > How can I permit the user to do this, while avoiding to give him root > access rights? Just a wakeup call here: if you let a user write C functions then you *are* giving him Postgres superuser rights. He can do anything he damn well pleases as user postgres, he's just got to write some code to do it. Once you've absorbed that, giving him the dbadmin password should not look unreasonable. regards, tom lane