I would like to secure some columns in my data warehouse. People who are generally allowed to query the database should get returned the columns but encoded. For example:
SELECT PERSON_ID FROM PERSON
PERSON_ID
-----------
yba986SDOAH
When some else who has the key queries in some way the table/columns then he/she should get the correct value.
Which options do i have in SQL Server > 2016?