Yes, Firebase / Firestore has this capability. You grant access to collections (and even fields) using rulesets[0].

Firestore is a NoSQL db so it's a quite different paradigmatically though.

[0] - https://firebase.google.com/docs/firestore/security/get-star...