What do you mean exactly? You can add collaborators to bases and manage access to bases, more capabilities if you have a pro account.
If adding too many collaborators is not ideal, you can create a users table but saving passwords their is obviously not secure.
I had a use case where I needed persons to login and edit their profile (base) record and it was not feasible to add hundreds of collaborators to a base, so I create a token based magic link (passwordless) login system. This requires use of the API.
You can check out my tutorial on how I did it here: