dbAuth authentication for active users

[chattago2002]

Hello.
I'm working with this repository and I'm proud to use it, it saves me a lot of time.

I need to understand if it's possible to do the following.
I use "dbAuth" in "middlewares" and authentication is working fine, reading username from "email" column and "password" from "hashed_pwd" column of "users" table.
However in this table I have an additional column with the "state" of the user (active or inactive), so I need to allow authentication only for active users.
How can this be made?

[mevdschee]

How can this be made?

You could make a view that holds only the active users and use that as the users table.

[chattago2002]

You could make a view that holds only the active users and use that as the users table.

Thanks you very much. I'm deeply absorbed in the project. A simple solution was in front of me but no able to see it. Thanks again

[mevdschee]

Great, thank you for your kind words. Let me know whether or not this works for you. Kind regards, Maurits

[chattago2002]

Great, thank you for your kind words. Let me know whether or not this works for you. Kind regards, Maurits

Yes, it's working fine. Thank you so much