Re: GRANT on all tables?

codeWarrior wrote:
> GRANT ALL TO PUBLIC;

Uh, that doesn't work, and actually we don't have a global 'give all
permissions on all tables' capability.


>
>
> "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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073