Hi @Balaji Rajandran Thank you posting your question. You can possibly prevent access to these columns using column level permissions Or create a view PostgreSQL: Documentation: 9.2: CREATE VIEW.
Regards,
Oury
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
We have a requirement to mask some of the columns in a table (Fox ex: IP Address, SSN )etc. We cant find any helpful information on how to mask columns in postgresql table. Pls. guide.
Hi @Balaji Rajandran Thank you posting your question. You can possibly prevent access to these columns using column level permissions Or create a view PostgreSQL: Documentation: 9.2: CREATE VIEW.
Regards,
Oury
Hi,
Thanks for your reply. We cant apply column level permission at the database side. We are looking for a solution as masking text in columns such as SSN, IP Address etc. From the front end, we will share plain text, but at the database we wanted to store the information like ..**.75 as an ip address, but at the same time admin should be able to see full text. This functionality is available in SQL server, but not able to get the solution in postgresql.