Re: Quick hack: permissions generator

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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461