Grant on several tables at once - Mailing list pgsql-admin

From MaRcElO PeReIrA
Subject Grant on several tables at once
Date
Msg-id 3F2AC832.7090803@yahoo.com.br
Whole thread Raw
Responses Re: Grant on several tables at once
Re: Grant on several tables at once
Re: Grant on several tables at once
List pgsql-admin
Hello All,

I have a database that contain 72 tables. How can I grant "SELECT" on
all those 72 tables to a user, at once?

I use to do:

# grant select on table1 to marcelo;
# grant select on table2 to marcelo;
# ...
# grant select on table72 to marcelo;

but it is a lot of tables... I would like to do this at once!

Thanks in advance and
Best Regards,

Marcelo


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Smaller template database?
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Grant on several tables at once