Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 687F22E2D3B for ; Tue, 4 Mar 2008 16:21:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96223-01-2 for ; Tue, 4 Mar 2008 16:21:36 -0400 (AST) X-Greylist: delayed 00:06:41.720629 by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 3E9B82E2D5F for ; Tue, 4 Mar 2008 16:21:34 -0400 (AST) Received: (qmail invoked by alias); 04 Mar 2008 20:14:50 -0000 Received: from f053002046.adsl.alicedsl.de (EHLO foxy) [78.53.2.46] by mail.gmx.net (mp005) with SMTP; 04 Mar 2008 21:14:51 +0100 X-Authenticated: #29095863 X-Provags-ID: V01U2FsdGVkX19UQ0ByFlFUyw4/pFOSwr5xnDqiNyO+AIXgvzPOV8 Uz9TdG5gmm0p9x From: "A Lau" To: , Subject: GRANT ALL ON recursive for all tables in my scheme? Date: Tue, 4 Mar 2008 21:14:50 +0100 Message-ID: <000f01c87e34$6b981fb0$0264a8c0@foxy> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914 Thread-Index: Ach+M7Y/GS8Ol/pQSF2dlkEKfHSCsA== X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/27 X-Sequence-Number: 28510 I recently searched for a way to grant permissions to a new created user for all tables in a scheme or database. I just found ways who uses psql and scripts. But I'm astonished that there is no way to do it with the "grant all on database [schema]..."-option. Actually i thought that a grant on a schema or database would recusivly set the accoding permissions to the corresponding objects (eg. tables, views...). Is there a way to do it easily in SQL-Syntax without psql and scripting? Why it can't be done with the grant-operator? thanks for help. Andreas