Re: GRANT on all tables? - Mailing list pgsql-admin

From codeWarrior
Subject Re: GRANT on all tables?
Date
Msg-id b7md50$1btl$1@news.hub.org
Whole thread Raw
In response to GRANT on all tables?  (dudsen <dudsen@koen.dk>)
Responses Re: GRANT on all tables?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
GRANT ALL TO PUBLIC;


"dudsen" <dudsen@koen.dk> wrote in message
news:1050499026.680723@kalvebod.groenjord.dk...
> How do I GRANT an user privileges for all tables in an database with one
> command, as it is now i need to specify the name of each table.
> I want to write something like
> GRANT SELECT,INSERT ON mydatabase TO user; this doesn't work but are there
a
> way of getting someting similar to work?
>
> --
> Daniel Udsen



pgsql-admin by date:

Previous
From: "John M. Layman"
Date:
Subject: trouble migrating large objects from 7.1.3 to 7.3.2
Next
From: Chris Loelke
Date:
Subject: converting from MySql