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 047EDD1B224 for ; Wed, 28 Jul 2004 15:15:14 -0300 (ADT) 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 81963-02 for ; Wed, 28 Jul 2004 18:14:44 +0000 (GMT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by svr1.postgresql.org (Postfix) with ESMTP id 82E13D1B181 for ; Wed, 28 Jul 2004 15:14:42 -0300 (ADT) Received: from [65.34.209.198] (c-65-34-209-198.se.client2.attbi.com[65.34.209.198]) by comcast.net (sccrmhc13) with SMTP id <2004072818144001600pe4ike>; Wed, 28 Jul 2004 18:14:41 +0000 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Wed, 28 Jul 2004 14:14:40 -0400 Subject: Re: How do I grant access to entire database at From: Randall Perry To: Tom Lane , Sam Barnett-Cormack Cc: , Message-ID: In-Reply-To: <9472.1090874787@sss.pgh.pa.us> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/304 X-Sequence-Number: 14372 What might be nice is a deductive syntax, so you can GRANT ALL and then remove privileges for certain objects: GRANT ALL ON DATABASE foo TO user EXCEPT... > It is perhaps interesting to do something like > GRANT SELECT ON TABLE foo.* TO user; > but I'm not sure this is so useful as to be worth enshrining in the > syntax. You could also argue that it's a potential security hole since > it'd be mighty easy to grant rights you didn't intend to on objects you > didn't realize would match the wildcard. (And that'd be true in spades > if the effect of the command were to automatically grant the same rights > on matching objects created in the future, which is what I think some of > the people asking for this sort of thing wanted. But I'm outright > scared of that idea.) -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Design/Development WebObjects Hosting Mac Consulting/Sales http://www.systame.com/