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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
