Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8DE3D2E3EF5 for ; Tue, 22 Jan 2008 11:27:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 31468-01-6 for ; Tue, 22 Jan 2008 11:26:58 -0400 (AST) Received: from depesz.com (depesz.com [88.198.37.40]) by postgresql.org (Postfix) with ESMTP id A2B902E33BB for ; Tue, 22 Jan 2008 11:23:59 -0400 (AST) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1JHKyh-000224-Dl; Tue, 22 Jan 2008 16:23:55 +0100 Date: Tue, 22 Jan 2008 16:23:55 +0100 From: hubert depesz lubaczewski To: Guillermo Arias Cc: pgsql-admin@postgresql.org Subject: Re: how to create a limited user Message-ID: <20080122152355.GA7655@depesz.com> Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/221 X-Sequence-Number: 27995 On Mon, Jan 21, 2008 at 03:49:55PM -0800, Guillermo Arias wrote: > Hi, i have a question: > > I have a database and i want to create a administrator user with total > control and another that only could make queries and could not see nor > modify the functions. > > The reason is that in the database that i will distribute are the > functions with a big part of the software logics and i do not want > these to be seen by my customers. basically - you're out of luck. as long as you use pl/pgsql source is in pg_catalog, and everybody can read it. you might use another languages (like pl/perlu, or even c) and put the code outside of sql access. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)