Join Discord
Powered by
Hello 🙂 Does anyone know if it's possible to use ...
# help
j
joshcawthorne
03/04/2022, 11:31 AM
Hello 🙂 Does anyone know if it's possible to use RLS to block requests for specific columns of data within a table?
g
garyaustin
03/04/2022, 2:00 PM
RLS is only for rows (it is like an extra where clause) You can use a view or an rpc function to hide or not return columns. Postgres has column level security, but it based on the database user (not uuid auth user) so may not fit.
https://www.enterprisedb.com/postgres-tutorials/how-implement-column-and-row-level-security-postgresql
j
joshcawthorne
03/04/2022, 2:07 PM
Thank you
@User
!
Previous
Next