Received: from mailout05.sul.t-online.com (mailout05.sul.t-online.com [194.25.134.82]) by hub.org (8.10.1/8.10.1) with ESMTP id e6MAjhh29467 for ; Sat, 22 Jul 2000 06:45:43 -0400 (EDT) Received: from fwd01.sul.t-online.com by mailout05.sul.t-online.com with smtp id 13Fwmo-0002Cz-04; Sat, 22 Jul 2000 12:45:38 +0200 Received: from hot.jw.home (340000654369-0001@[62.158.180.165]) by fwd01.sul.t-online.com with esmtp id 13Fwmj-2ASdiyC; Sat, 22 Jul 2000 12:45:33 +0200 Received: (from wieck@localhost) by hot.jw.home (8.8.5/8.8.5) id LAA08325; Sat, 22 Jul 2000 11:11:51 +0200 From: JanWieck@t-online.de (Jan Wieck) Message-Id: <200007220911.LAA08325@hot.jw.home> Subject: Re: create function - user permissions In-Reply-To: <3978E056.CF082AF7@mail.uni-mainz.de> from Markus Wagner at "Jul 22, 2000 01:44:22 am" To: markus.wagner@bigfoot.com Date: Sat, 22 Jul 2000 11:11:51 +0200 (MEST) CC: pgsql-sql Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Sender: 340000654369-0001@t-dialin.net X-Archive-Number: 200007/223 Markus Wagner wrote: > Hi, > > 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? Assuming with "root" access you mean "DB-superuser" rights. No way! From the C language, he has total access to the DB backend, running under the OS-side database system owners UID. That means, he has complete OS access to the entire DB installation! He could read/write system catalogs without any permission checks (SPI is only for convienience, someone can use heap-am as well). So in fact, he IS a superuser then. And that should be reflected in his rights. Giving him the right would also prevent him from doing stupid things to gain access for data he shouldn't have, possibly corrupting you DB installation by accident. If that all isn't an option for you, give him his own DB installation where he is his own superuser. There he can develop those things and after code revision, you install the modules in the production system. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #