On 29/1/19 10:39 π.μ., Thomas Kellerer wrote:
> JD schrieb am 29.01.2019 um 09:02:
>> Hi Team,
>> Is there any way to mask the column value (*******) in postgresql?
> You could create a view that does that and only give access to that view, rather than the underlying table.
IMHO this should fall under RLS. Something that could be called CLS (Column Level Security). Dalibo's anonymizer seems promising, if only it could be integrated in RLS framework . That would mean
instant GDPR :)
IT DEV Lead
Dynacom Tankers Mgmt
Row-level security must be enabled on the table by using ALTER TABLE... ENABLE ROW LEVEL SECURITY in order for creating policies to be applied. If row-level security is enabled for a table, but no applicable policies exist, a default deny policy is assumed that no rows will be visible or updatable.