X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7F3349DC80A for ; Wed, 1 Mar 2006 13:49:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48464-02 for ; Wed, 1 Mar 2006 13:49:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 01AB29DC949 for ; Wed, 1 Mar 2006 13:49:00 -0400 (AST) Received: (qmail 2436 invoked by uid 500); 1 Mar 2006 17:59:04 -0000 Date: Wed, 1 Mar 2006 11:59:04 -0600 From: Bruno Wolff III To: Michael James Cc: chester c young , pgsql-sql@postgresql.org Subject: Re: grant select,... over schema Message-ID: <20060301175904.GA2098@wolff.to> Mail-Followup-To: Bruno Wolff III , Michael James , chester c young , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.099 required=5 tests=[AWL=0.099] X-Spam-Score: 0.099 X-Spam-Level: X-Archive-Number: 200603/13 X-Sequence-Number: 24359 On Tue, Feb 28, 2006 at 09:43:58 -0700, Michael James wrote: > GRANT ALL PRIVILEGES ON databaseName To username; This won't do what he wants. This will not grant access to objects contained in the database, only a few specific privileges. There is no single command that does this, but it isn't hard to write scripts to do things like this. For each object type you want to grant access to, you can query the catalogs to get a list of those objects and then generate appropiate grant statements and execute them. > > Michael Lee James | Database Administrator > d. 480-282-6043| c. 480-505-5802| f. 480-505-5801 > mjames@icrossinginc.com > iCrossing, Inc. | Driving the Future of Advertising > New York | Chicago | Scottsdale | San Francisco > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of chester c young > Sent: Tuesday, February 28, 2006 9:35 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] grant select,... over schema > > is there any way to grant over all applicable objects in a schema, > > > grant select on schema pop to public; <-- wrong > > without specifically granting the select on each table? > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > iCrossing Privileged and Confidential Information > This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information of iCrossing. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster