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