Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
Although I am not an expert, I will suggest reading the following article on the c-sharp corner:
This details the process fairly well and has some working examples posted in a way that i feel might suit your application.
