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
