Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 417912E0106 for ; Tue, 4 Mar 2008 19:59:59 -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 34840-08 for ; Tue, 4 Mar 2008 19:59:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by postgresql.org (Postfix) with ESMTP id B5BA32E00DD for ; Tue, 4 Mar 2008 19:59:55 -0400 (AST) Received: from charon.medialogik.com (charon.medialogik.com [72.51.27.114]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id B9BED4AAB for ; Tue, 4 Mar 2008 15:59:52 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-general@postgresql.org Subject: Re: GRANT ALL ON recursive for all tables in my scheme? Date: Tue, 4 Mar 2008 16:00:39 -0800 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) References: <000f01c87e34$6b981fb0$0264a8c0@foxy> In-Reply-To: <000f01c87e34$6b981fb0$0264a8c0@foxy> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803041600.39195@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/112 X-Sequence-Number: 129434 On Tuesday 04 March 2008, "A Lau" wrote: > 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? > Normally you would have a group role or roles that have appropriate permissions already, and then just grant role to new_user for group membership. -- Alan