Re: REVOKE from all tables ...

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: REVOKE from all tables ...
Дата
Msg-id 20050809021939.J1002@ganymede.hub.org
обсуждение исходный текст
Ответ на Re: REVOKE from all tables ...  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin
On Mon, 8 Aug 2005, Joshua D. Drake wrote:

> Marc G. Fournier wrote:
>
>>
>> Is there a way of REVOKEing privileges on all tables in a database?  I've
>> checked the REVOKE man page, and there doesn't appear to be, but I figured
>> I'd double check to make sure ...
>
> No. This has actually been a requested feature on the grant side as well...
> Nothing a simple for loop can't do with perl though.

Ya, that is what I did, it just seemed that there should be a much
simplier way of doing it :(  Ah well, at least I wasn't re-creating the
wheel on this one :)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: REVOKE from all tables ...
Следующее
От: "josh@segrestfarms.com"
Дата:
Сообщение: SQL Server 2000 to PostgreSQL 8.0.3