How to setup postgresql database connection with different roles via django?

Question

Django

Several roles with different rights are created in the database. For example, unlogged_role is a role that has access to queries and inserts into the user table (an unlogged user can create an account or log in, respectively). There is a logged_role role, which has more extensive features.
Then the corresponding users are created in the database with the given roles.

create user unlogged_user with password '1';
grant unlogged_role to unlogged_user;

In code, the connection looks like this: The

question is how to switch between these database users in the program.

Answer 1

Write your manager