pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedgrant select on ALL(?) to dbuser;
3+ messages / 2 participants
[nested] [flat]
* grant select on ALL(?) to dbuser;
@ 2000-10-03 09:36 Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
2000-10-03 12:01 ` Re: grant select on ALL(?) to dbuser; Antti Linno <alligator@all.ee>
0 siblings, 1 reply; 3+ messages in thread
From: Marcin Mazurek @ 2000-10-03 09:36 UTC (permalink / raw)
To: pgsql-sql
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: grant select on ALL(?) to dbuser;
2000-10-03 09:36 grant select on ALL(?) to dbuser; Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
@ 2000-10-03 12:01 ` Antti Linno <alligator@all.ee>
2000-10-03 12:01 ` Re: grant select on ALL(?) to dbuser; Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
0 siblings, 1 reply; 3+ messages in thread
From: Antti Linno @ 2000-10-03 12:01 UTC (permalink / raw)
To: Marcin Mazurek <M.Mazurek@poznan.multinet.pl>; +Cc: pgsql-sql
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/
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: grant select on ALL(?) to dbuser;
2000-10-03 09:36 grant select on ALL(?) to dbuser; Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
2000-10-03 12:01 ` Re: grant select on ALL(?) to dbuser; Antti Linno <alligator@all.ee>
@ 2000-10-03 12:01 ` Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
0 siblings, 0 replies; 3+ messages in thread
From: Marcin Mazurek @ 2000-10-03 12:01 UTC (permalink / raw)
To: pgsql-sql
Antti Linno (alligator@all.ee) napisał:
> 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.
i want to do it via cron, and rather not user any superusers, except for
this it whould by nice to know how to do it not only for pg_dump:)
maz
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-10-03 12:01 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-03 09:36 grant select on ALL(?) to dbuser; Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
2000-10-03 12:01 ` Antti Linno <alligator@all.ee>
2000-10-03 12:01 ` Marcin Mazurek <M.Mazurek@poznan.multinet.pl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox