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