AKHILESH GUPTA wrote:
> here i have to grant permissions to that user individually for each and
> every table by using:
> :->> grant ALL ON <tab_name> to <user_name>;
> GRANT
> and all the permissions are granted to that user for that particular table.
Yes. If you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support