Hide a column?
I want to create a simple board where authenticated users can publish posts.
I want the author of a post in my database (it is currently an author column in my posts table, referencing the built-in auth.users id).
However, I want the posts to by anonymous, so no user should be able to retrieve the author from a post (maybe except the actual author).
How can I restrict access for my users to that column?
I can create a view with only all tha other columns, but when you know the original table name, it is still accessable.
Afaik, I cannot apply separate RLS rules to views, or can I?
Is there a different way to securely restrict access to a column?
I want the author of a post in my database (it is currently an author column in my posts table, referencing the built-in auth.users id).
However, I want the posts to by anonymous, so no user should be able to retrieve the author from a post (maybe except the actual author).
How can I restrict access for my users to that column?
I can create a view with only all tha other columns, but when you know the original table name, it is still accessable.
Afaik, I cannot apply separate RLS rules to views, or can I?
Is there a different way to securely restrict access to a column?
