Questions tagged [pii]

PII stands for Personally Identifiable Information -- that information which can uniquely identify an individual.

PII stands for Personally Identifiable Information -- that information which can uniquely identify an individual.

Some examples of PII include phone number, home address or (in the USA) social security number.

Some locations will have laws requiring information systems implementers to protect PII for users of their systems. Protecting PII (especially on the internet) has become more and more important as interests looking to discover PII have prevalent.

However, PII is a legal concept, not a technical concept. Because of the versatility and power of modern re-identification algorithms, the absence of PII data does not mean that the remaining data does not identify individuals. While some attributes may be uniquely identifying on their own, any attribute can be identifying in combination with others.

80 questions
0
votes
1 answer

. NET Core Data protection API or Always encrypted

I have .NET Core Web API microservices with MS SQL and elastic search(NoSql). I want to encrypt PII(Personal Identifiable Information) both in Elasticsearch and MS SQL database. Which is better option to use .NET data protection API or always…
jaspreet chahal
  • 8,817
  • 2
  • 11
  • 29
0
votes
1 answer

Which natural languages does Google Cloud DLP support?

I'm considering using Cloud DLP to help me anonymize my data. However, I can't seem to find explicit mention of what languages are supported. AWS Comprehend's detect PII API only supports English so looking for an alternative.
kylejmcintyre
  • 1,898
  • 2
  • 17
  • 19
0
votes
1 answer

Google Cloud DLP Re-identify PII data using Deterministic encryption

I was experimenting with Google provided the article to re-identify Credit Card Number using Deterministic encryption using…
0
votes
0 answers

How to fire like and range query on PII encrypted column in mysql

I have different encrypted columns in my MySQL table for different PII data like email, date of birth, etc.I am using AES envelope encryption coupled with AWS KMS. The encryption and decryption is handled in the application. No MySQL inbuilt…
0
votes
1 answer

Netsuite : personal information (PI) removal

We have an Amazon MWS API connector that imports data into Netsuite (NS) for shipping and order creation. It is obvious that Amazon data includes PII (Personal Identifiable Information. Amazon policy). Amazon requests that PII never be recorded in…
fullstack.studio
  • 320
  • 1
  • 10
0
votes
1 answer

Oracle Data Masking Clarification

Hi I am looking at the possibility of implementing the Oracle Data Masking Package but require some clarification. I am looking to mask just my non-production data. In the process of doing this does Oracle create clones of the the database? I am…
0
votes
1 answer

De-Identifying PHI For HIPAA

I have a SQL DB which contains PHI, hosted on AWS. I want to access this data to perform analytics, however, I must de-identify the data first to comply with HIPAA. How should I approach this? I have thought of a few approaches: Simply de-identify…
user13514973
0
votes
1 answer

How to check a column for valid values in csv using regex?

I have a CSV file with columns [Name,Email, Address, Credit Card]. I want to apply regex on each column and check whether that column is valid or not. For example, the email column should contain all the email values. for i in df['Email']: …
0
votes
1 answer

Cloud DLP inspection scan to look for multiple infoTypes in same row

I have to run an inspection scan on a Big Query Table. My goal is to highlight/find a row only if it contains say, first_name, last_name, Phone_number & age infoTypes (*all in same row). I'm new to Cloud DLP and have created a Job trigger (with all…
0
votes
1 answer

SQL Server view for PII and Non PII end user

I have situation where I need to create a view which will be used by end user who may have PII and NON-PII permission clearance controlled by AD groups. Say i have dim_customer which contains four columns ID, Name, DoB, Country. When PII user runs…
Anbu Dhan
  • 73
  • 2
  • 10
0
votes
1 answer

How to run Cloud DLP (Data Loss Prevention) in all Big Query tables in my project?

As per the DLP docs, when you create an Inspect Job, you need to specify the table reference: { "inspectJob":{ "storageConfig":{ "bigQueryOptions":{ "tableReference":{ "projectId":"bigquery-public-data", …
0
votes
0 answers

Django Allauth / User Model Encrypt Username and Email For PII Compliance

Is it possible to encrypt the username and email for Allauth to be PII compliant? If so, how would you do that? If this is possible, how would a site admin go about decrypting the username and email in case they needed to contact the user? Not sure…
0
votes
1 answer

Types of PII for queries into AWS macie

I tried to make a query for classifying my documents using macie. But i don't know how i can find documents with driver licenses or National Identifications number... In the examples that it use aws, appear pii_type: "mail" for email or pii_types:…
user8079405
0
votes
1 answer

Looking for guidance on how to generate a db with random PII data

Hi I am looking to get some help on ideas (or existing tools) on how to have a script that generate sample (fake) names, addresses, phone numbers, etc and populate a csv or mysql db. The purpose for this is to test a script that can identify or…
0
votes
0 answers

is it ok to store salt and encypted SSN using AES 256 in same table

I am using AES256 algorithm to encrypt SSN ( because I want to decrypt that and show it to user on UI ). Will it be ok to store SSN specific salt and encrypted password in same table ?
Sagar
  • 645
  • 2
  • 9
  • 31