Re: Quick hack: permissions generator

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: Quick hack: permissions generator
Дата
Msg-id 20051213102822.GA4864@l-t.ee
обсуждение исходный текст
Ответ на Re: Quick hack: permissions generator  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
On Mon, Dec 12, 2005 at 09:36:27PM -0600, Jim C. Nasby wrote:
> On Mon, Dec 12, 2005 at 02:38:57PM +0200, Marko Kreen wrote:
> >
> > I needed to re-set all permissions on a database as the database
> > access philosophy changed.  But as it had a lot of tables, I was
> > losing overview very quick.  The original permission script used
> > m4 for SQL generation, but it didn't cut anymore.
> >
> > So I wrote a small Python script which read a .ini-style config
> > file for input.  And it ended up being surprisingly clear and
> > effective.  As it seems to be generally useful, I post it here.
> >
> > The basic assumption is that user has couple of groups of tables
> > that have somewhat different access pattern for couple of user
> > groups.  Small example:
>
> Seems neat. I suggest putting it on http://pgfoundry.org.

Thanks.  I'll consider it.

--
marko


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

Предыдущее
От: Rich Doughty
Дата:
Сообщение: Re: View with an outer join - is there any way to optimise
Следующее
От: Sim Zacks
Дата:
Сообщение: Re: pg_autovacuum