how to revoke multiple users permission from multiple tables at the same time?

Поиск
Список
Период
Сортировка
От DM
Тема how to revoke multiple users permission from multiple tables at the same time?
Дата
Msg-id eae6a62a0904221519x5abc9b20ne55c6eacb25e1c80@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to revoke multiple users permission from multiple tables at the same time?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
Дерево обсуждения
how to revoke multiple users permission from multiple tables at the same time?
Or in simple is there a way to revoke multiple users grant access from multiple tables under a schema.?

I use Revoke below command to execute on each table one by one.

revoke SELECT/ALL on testtable from user1;

Thanks for taking your time to read this.

thanks
Deepak

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Logs say update done but not actually done or committed into database ???
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: how to revoke multiple users permission from multiple tables at the same time?