X-Original-To: pgsql-admin@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 8A8E94763E8
	for <pgsql-admin@postgresql.org>; Wed, 14 May 2003 13:34:10 -0400 (EDT)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	ESMTP id 09922-03 for <pgsql-admin@postgresql.org>;
	Wed, 14 May 2003 13:34:09 -0400 (EDT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id C6D404763D4
	for <pgsql-admin@postgresql.org>; Wed, 14 May 2003 13:34:08 -0400 (EDT)
Received: (qmail 4055 invoked by uid 500); 14 May 2003 17:35:35 -0000
Date: Wed, 14 May 2003 12:35:35 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Travis Whitton <whitton@atlantic.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Grant Question
Message-ID: <20030514173535.GA3260@wolff.to>
Mail-Followup-To: Travis Whitton <whitton@atlantic.net>,
	pgsql-admin@postgresql.org
References: <slrnbc045f.42h.whitton@grub.ath.cx>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <slrnbc045f.42h.whitton@grub.ath.cx>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/180
X-Sequence-Number: 8742

On Mon, May 12, 2003 at 21:11:47 +0000,
  Travis Whitton <whitton@atlantic.net> wrote:
> 
> dummy=# GRANT ALL ON DATABASE dummy TO devel;
> GRANT

Granting all on a database allows the grantee to create schemas and
temporary tables in that database. It doesn't grant access to any
tables in that database. To do that you want to write a script that
does a query to get a list of table names and then issue grant
statments for those tables.