question

jangi avatar image
jangi asked

finding sensitive data columns

In Oracle there is a way to find the sensitive data columns (Application Data Modelling). Is there any way to find the sensitive data columns in sql server like SSN, credit card no................?
sql server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
You will need to seach on the all_tab_columns table. Using the "IN" statement add the names you need. select table_name, column_name from all_tab_columns where column_name in ('SSN', 'DOB', 'CCN', 'POSTCODE') Or to wildcard it, just in case. select table_name, column_name from all_tab_columns where column_name like '%SSN%' You could also download Column search from [Idera][1]. This will not work against Oracle, but it would give you the strings they are searching for [1]: https://www.idera.com/productssolutions/freetools/sql-column-search
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.