How could I configure it so that the user who is logging in is a user of a PostgreSQL database manager?

I am developing a web application, I would like to know how I can configure it so that the user who is logging in is a user of the PostgreSQL database manager, generally there is a superuser who has permissions to freely manage all the databases, but other users with a lower hierarchy can be added, so I would like it to be possible to access as such with those users created in the DBMS. I use python as programming language and django as framework.

I really have no idea how to achieve this functionality, I'm starting my studies, I want to surprise my database teacher with something different from the rest of the students, and I would like someone to help me with this, I don't expect a complete solution, just a guide and references to be able to achieve what is proposed

Back to Top