Amazon web services – Redshift Column Permission & "Select *"
According to AWS docs, a user with column permission on a table/view should still be able to perform "SELECT *" and retrieve the column that they have access to. From Usage notes for column-level: If you don't have the SELECT…