Re: Restricting database permissions

2009-09-07 Thread Jason Beaudoin
On Mon, Sep 7, 2009 at 10:09 AM, Thomas Guettler wrote: > > I can speak only for postgres. > > We create the database with a special admin-account and > the owner if the db is the admin-account. Then we grant > insert, update, delete permissions to the django-db-user. > > We

Re: Restricting database permissions

2009-09-07 Thread sean
Hi Thomas, Thank you for your suggestion. The modified manage.py sounds like a very good place for me to start. Best regards, Sean On Mon, 2009-09-07 at 16:09 +0200, Thomas Guettler wrote: > I can speak only for postgres. > > We create the database with a special admin-account and > the

Re: Restricting database permissions

2009-09-07 Thread Thomas Guettler
I can speak only for postgres. We create the database with a special admin-account and the owner if the db is the admin-account. Then we grant insert, update, delete permissions to the django-db-user. We have a modified manage.py which let syncdb run with the admin-account (interactive password

Restricting database permissions

2009-09-07 Thread sean
Hi All, I am currently working on a front end to pam-mysql and nss-mysql to allow the creation of linux user accounts through the web. I need to separate out permissions so that Django can read some columns and not others, for instance it should have no access to the password column. I