[GENERAL] Newbie Question, how to grant permissions on all tables in schema/db

2004-11-08 Thread Kenji Morishige
Hi guys, I'm wondering what the easy way to grant user/group access on all tables in a db. I just migrated about 200 tables from my MySQL database using a cool migration script, but now all the tables are owned by me in the schema public. That is all fine and all, but I wish I could run a

Re: [GENERAL] Newbie Question, how to grant permissions on all tables in schema/db

2004-11-08 Thread Michael Fuhr
On Mon, Nov 08, 2004 at 05:00:49PM -0800, Kenji Morishige wrote: I'm wondering what the easy way to grant user/group access on all tables in a db. This comes up from time to time -- search the archives for phrases like grant and all tables. The responses usually suggest writing a script or