Create Read-Only MySQL Database Connection in Django

Question

Is it possible to add a connection to a database so when using it only select queries are allowed?

Something like this would be great:

DATABASES = {
    #can do update, insert, etc...
    'default': { 
        'ENGINE': 'django.db.backends.mysql',
        'USER': 'root',
        'PASSWORD': '12345',
    }
    #select only
    'default_readonly': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mydb',
        'PASSWORD': '12345',
        'READONLY': True,

    }
}

I didn't find anything simple.

Answer 1

As far as I know, Django does not provide any options to restrict the database connection to a "read-only" mode. However, you can do it by creating a readonly user in your MySQL database engine.

Another idea, on the Django code side, would be to create your own cursor, which throws exception if execute or executemany is called. You can look at this module django-db-readonly.