GRANT ALL TO PUBLIC;
"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