Thursday, February 23, 2017

Connecting to a database with logged in user credentials

Is it possible to create database ENGINE that would be able to pass credentials of logged in user to DatabaseWrapper.connect() method?

We want to build rest api with Django that would base on a legacy Postgresql database. We've got permissions to objects ensured on database level, so a user logged in to database cannot see/modify anything he should not to.
We have a very strong need not to destroy this mechanism. This means that every application user is at the same time a database user.
After starting the project, we've realised that db routing is limited to the set of db connections that are statically described in django settings.
Is there a way to create database connection dynamically based on the currently logged in user?
In ideal we would like to pass kerberos credentials from the frontend throug api to the database.

Thanks in advance for any clues,
Konrad Perzyna

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/75ae1155-f2b2-43d6-a616-839f0c886bcb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment