I have n schemas on my PostgreSQL server (V9.2) and n users (1 user per schema). I just want to assign the privileges `SELECT, INSERT, UPDATE, DELETE, EXECUTE` for `user1` to `schema1`, for `user2` to `schema2`, for `usern` to `scheman` on each table.

I can not do this with this statement :

```
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON SCHEMA schema 1 to user1

```

because the clause `...ON SCHEMA` works only with `CREATE` and `USAGE` privileges.

So what is the fastest way to assign all those privileges on each tables to concerned user please ? I hope the only way is not to do one `GRANT` statement per `schema.table`...?