> For example I have 5 tables in database A. And now I want to give
> SELECT/UPDATE/INSERT privileges to a user to all 5 tables. But according
to
> documentation, I have to execute 'GRANT' query 3 times(for
> select/update/insert) per table. meaning total of 15 times!!!!
That's incorrect... you can do it all in one statement:
GRANT select,update,insert TO "<username>" ON table_1,table_2,table_3,etc
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm
-Dan