I've a requirement to keep a user table for granting access to an application where there's a password field which has to be masked.
How to go about it?
Example: If you query select * from PG_USER;
in Redshift, you'd see, the password column values are shown as *****
. How to do exactly that for my custom table?
If there is a column in a table that you do not wish particular users to see, then:
CREATE VIEW
to select all columns you do wish them to be able to viewOr, create a table without the offending column and grant them permission to use that table.