Received: from all.all.ee (puu.all.ee [194.204.49.113]) by hub.org (8.10.1/8.10.1) with ESMTP id e93C21r18433 for ; Tue, 3 Oct 2000 08:02:01 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id PAA11125; Tue, 3 Oct 2000 15:01:30 +0300 Date: Tue, 3 Oct 2000 15:01:30 +0300 (EEST) From: Antti Linno To: Marcin Mazurek cc: pgsql-sql@postgresql.org Subject: Re: grant select on ALL(?) to dbuser; In-Reply-To: <20001003113653.A30185@poznan.mtl.pl> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id e93C22r18435 X-Archive-Number: 200010/17 Hm, I usually use pg_dump -f smthng.out dbname -u after that program asks for username and password, there were some possibilities within postgres too, but you can find them yourself. And why not to dump all data as superuser, that way u have no problems with privileges at all. Antti On Tue, 3 Oct 2000, Marcin Mazurek wrote: > Hi, > is something like this possible? > I have to grant select priviliges to dump database, and I was wondering if > there is easer way to do it then name one, by one every table. > > maz > > Marcin Mazurek > > -- > Kierownik Działu Systemowego > MULTINET SA o/Poznan > http://www.multinet.pl/ >