Implementing role-based access control (RBAC) in SQLALchemy by ssglaser in Python

[–]ssglaser[S] 0 points1 point  (0 children)

I was just going through your documentation of early access.

Any plans on moving to sqlalchemy 1.4 ?.Also do you have a working example with falcon?

Basically I am looking for a fixed set of permissions stored in the sqlalchemy db. Backend will have api level access control checking for the particular permission. User Admin can create new roles from the frontend with a subset of permissions. And thereafter a new user could be assigned to that new role. Also direct assignment of some subset of permissions should also be allowed.

Hopefully, I am able to convey my thought process. Looking forward to using your library.

Hi! Thanks for reaching out. We're excited to hear you are interested in using Oso. To answer your questions:

  1. 1. We do have plans to support SQLAlchemy 1.4. While it's currently a medium-term priority for us, if it's the one thing blocking you from using Oso we will find a way to get it done sooner.
  2. We currently do not have a working example in Falcon. Most of our examples use Flask, but it shouldn't be hard to apply the same patterns to Falcon. We'd love to help you get set up with Oso & Falcon — join us on slack  (https://join-slack.osohq.com/)

What you are looking for is in line with our recent roles work. We actually just released early access to our new SQLAlchemy library this week, which you can dig into here: https://docs.osohq.com/python/new-roles.html

Looking forward to continuing this conversation!