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(at)koen(dot)dk> wrote in message
> news:1050499026(dot)680723(at)kalvebod(dot)groenjord(dot)dk(dot)(dot)(dot)
> > 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(at)postgresql(dot)org
>

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