Hello there,
Is it possible to force database access to be read-only when executing
custom SQL?
I want to make a simple admin application that lets my clients execute
some SQL code (only "SELECT" queries, so they can pull out some data
when they need). I don't want them to mess up the database so I'd like
to force the read-only access for whatever they execute.
My model is:
class Query(models.Model):
name = models.CharField(max_length=255)
sql = models.TextField()
description = models.TextField(blank=True)
def execute(self):
from django.db import connection
cursor = connection.cursor()
cursor.execute(self.sql)
row = cursor.fetchall()
return row
class Admin:
pass
What should I change to force the read-only access?
Thanks a lot!
Julien
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
