X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 12AF23A5A82 for ; Tue, 11 Jan 2005 20:26:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75471-07 for ; Tue, 11 Jan 2005 20:26:19 +0000 (GMT) Received: from out008.verizon.net (out008pub.verizon.net [206.46.170.108]) by svr1.postgresql.org (Postfix) with ESMTP id 128B63A5A5E for ; Tue, 11 Jan 2005 20:26:19 +0000 (GMT) Received: from boojiboy.metrosplash.com ([66.15.181.204]) by out008.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050111202618.FZCV17379.out008.verizon.net@boojiboy.metrosplash.com>; Tue, 11 Jan 2005 14:26:18 -0600 Subject: Re: Limiting user privileges From: Tad Marko To: Michael Fuhr Cc: pgsql-admin@postgresql.org In-Reply-To: <20050110183111.GA2279@winnie.fuhr.org> References: <1105377550.11245.0.camel@boojiboy.metrosplash.com> <20050110183111.GA2279@winnie.fuhr.org> Content-Type: text/plain Date: Tue, 11 Jan 2005 14:26:15 -0600 Message-Id: <1105475175.8275.7.camel@boojiboy.metrosplash.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH at out008.verizon.net from [66.15.181.204] at Tue, 11 Jan 2005 14:26:15 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/68 X-Sequence-Number: 15927 On Mon, 2005-01-10 at 11:31 -0700, Michael Fuhr wrote: > On Mon, Jan 10, 2005 at 11:19:10AM -0600, Tad Marko wrote: > ... earlier comments regarding schemas and privileges ... Now I'm a bit closer to having things working, but I seem to be running into another problem granting the privileges I want for a given user. I can GRANT ALL ON a_specific_table TO user but I can't figure out how to simply give some privilege to a user on all tables. I'm pretty sure that I don't have my head wrapped around schemas well enough, so maybe what I ought to be asking is how do I create a database in a new schema and then use the schema to control user access??? Thanks, Tad -- Tad Marko