That stood out to me as well. I've been playing with pgvector, and there's no reason you can't use row/table role-based security.

I think there's an unmentioned benefit to using something like pgvector also. You don't need a separate relational database! In fact you can have foreign keys to your vectors/embeddings which is super powerful to me.