Postgres offers some views and filters by account or something if I recall, but I don't know anything about it (and I'd still be skeeved out by giving someone raw database access when the system hadn't been designed from the ground up for it).

https://www.postgresql.org/docs/current/ddl-rowsecurity.html