Grant on several tables at once

Поиск
Список
Период
Сортировка
От MaRcElO PeReIrA
Тема Grant on several tables at once
Дата
Msg-id 3F2AC832.7090803@yahoo.com.br
обсуждение исходный текст
Ответы Re: Grant on several tables at once  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Re: Grant on several tables at once  (Andreas Pflug <pgadmin@pse-consulting.de>)
Re: Grant on several tables at once  (sforteln@fhcrc.org)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Smaller template database?
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Grant on several tables at once