Message-Id: <4D932ABC020000250003BF9D@gw.wicourts.gov>
Date: Wed, 30 Mar 2011 13:06:04 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	"Marc Fromm" <Marc.Fromm@wwu.edu>
Subject: Re: grant select script
References: 
 <93361C67E4EE844A80935863A4FF4B6C04E613C3@Exch2010MB-2.univ.dir.wwu.edu>
In-Reply-To: 
 <93361C67E4EE844A80935863A4FF4B6C04E613C3@Exch2010MB-2.univ.dir.wwu.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Marc Fromm <Marc.Fromm@wwu.edu> wrote:
 
> I am working with a script to automate grant select to all tables
> in a database to a user.
 
You don't say what version you're using, but if it's available, you
might want to use the GRANT SELECT ON ALL TABLES IN SCHEMA syntax.
 
> The data base cswe2 does not contain the table sql_languages,
> unless it is hidden. Is there a way to tell the script to ignore
> them?
> GRANT SELECT ON TABLE sql_languages to tom;
> ERROR:  relation "sql_languages" does not exist
 
It looks like you're not dealing with schema properly.  To learn how
to write queries for that, it can help to run psql with the -E
switch and use the \d commands.
 
-Kevin