Best practice to protect users sensitive data
Hi everyone !
I have a table users with columns username, first_name and last_name.
My problem is:
I need a policy that allows SELECT column username to ANON
But first_name and last_name are sensitive data, and I don't want to allow the access to anyone
Do you know a way for me to slice these permissions separately ?
I was thinking about finding a way to separate the permissions granted in one policy. Or create another table just for sensitive data.
Do you have a better way ?
I have a table users with columns username, first_name and last_name.
My problem is:
I need a policy that allows SELECT column username to ANON
But first_name and last_name are sensitive data, and I don't want to allow the access to anyone
Do you know a way for me to slice these permissions separately ?
I was thinking about finding a way to separate the permissions granted in one policy. Or create another table just for sensitive data.
Do you have a better way ?
