Newbie Question, how to grant permissions on all tables in schema/db - Mailing list pgsql-general

From Kenji Morishige
Subject Newbie Question, how to grant permissions on all tables in schema/db
Date
Msg-id 20041109010049.GC9988@juniper.net
Whole thread Raw
Responses Re: Newbie Question, how to grant permissions on all tables in schema/db
List pgsql-general
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 command like:

grant all on * to group developers;

where developers contain my created users.

is there a way to do this easily?

Thanks in advance!
-Kenji

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: INTERVAL in a function
Next
From: Tom Lane
Date:
Subject: Re: server auto-restarts and ipcs