Views for Restricting Data Access
What's the recommended approach for restricting access to columns in a table. For example, if I have a user_profiles table, but I only want some users to see all the columns, how can I accomplish this? If a view is implemented with
security_invoker doesn't this mean the user can just access the data directly in the table if they wanted to?