Questions tagged [anonymize]

An anonymizer is a tool that de-identifies or masks data/event unidentifiable. It could be a proxy server that acts as a shield between internet and the local network or it can be a tool that consumes data from the source and modifies it into a untraceable data into the destination(like removal of sensitive/protected information).

79 questions
0
votes
0 answers

create extension for anonymize failing

I'm interested in trying to 'anonymize' a field using static masking in Postgres Greenplum using code from this site: https://postgresql-anonymizer.readthedocs.io/en/latest/static_masking/ The code I'm starting with this (on a Greenplum server using…
Ben999
  • 1
0
votes
1 answer

How can I query what security labels exist on a table?

Using the postgresql-anonymizer Postgres extension I've set security labels for masking on a number of columns. e.g. SECURITY LABEL FOR anon ON COLUMN "Customer"."firstName" IS 'MASKED WITH FUNCTION anon.fake_first_name() I want a way to query if…
Todd Drinkwater
  • 379
  • 6
  • 17
0
votes
1 answer

anonymize_table appears to convert table names input to lowercase

I'm testing out using anonymize_table(table_name) via postgresql-anonymizer on a database to attempt to anonymise data. However, when using the command SELECT anon.anonymize_table('Users'). It returns the error message: ERROR: column "Users" does…
Todd Drinkwater
  • 379
  • 6
  • 17
0
votes
0 answers

What are 'officially approved' implementations to anonymize LONG values (id in table) for GDRP requirements

I want to create an anonymized version of a table where one of the id fields (long) needs to be anonymized. The table is queried by a huge number of different business stake holders so I would prefer to not change the field type in order to minimize…
Jeroen Dirks
  • 7,705
  • 12
  • 50
  • 70
0
votes
0 answers

Issues with setting up CryptopANT IP address anonymization library

Errors with compiling CryptopANT binaries: > gcc scramble_ips.c -o scramble_ips produces scramble_ips.c: In function ‘main’: scramble_ips.c:354:16: error: ‘regex4’ undeclared (first use in this function); did you mean ‘regexec’? …
bytewolf
  • 1
  • 1
0
votes
0 answers

How to set attribut weight and hierarchy maximum level in arx api

I am using the pyarxaas python library to anonymization data. I have created a basic example using it and it is working fine. Now, I want to set a maximum limit of the hierarchy for the specific column as well as I want to add attribute weight using…
Hkachhia
  • 4,463
  • 6
  • 41
  • 76
0
votes
1 answer

ModuleNotFoundError: No module named 'anonymizer.anonymization'

Getting this error: (blur) D:\anonymizer-master\anonymizer\bin>python anonymize.py Traceback (most recent call last): File "anonymize.py", line 20, in from anonymizer.anonymization import Anonymizer By Running this file: import…
YoungIN
  • 3
  • 2
0
votes
2 answers

Is there a way to anonymize a list of names by replacing the letters with asterisks in Excel?

I have a list of names in a column e.g.: Bob Adam Smith, Steve Jobs, Stacy Jones I’d like to use these names for a case study presentation, but they have to be anonymized. I imagine something like: B@b A@@m S@@@h, S@@@e J@@s, S@@@y J@@@s But with…
Sara123
  • 3
  • 2
0
votes
0 answers

MS SQL Server Data Anonymise

I have this requirement: we are going to restore production database into UAT for testing few use cases. We should anonymise required data (Ex: SSN, Credit Card etc) from all types of users (including sysadmin, db owner). No one should be able to…
0
votes
1 answer

Simple, good-looking crosstabs that allow anonymization

Is there an easy way to annonymize crosstabs created with the tbl_cross function from the gtsummary package? Or is there an alternative package that I can just use? For example, I want to anonymize all values that are >5.
litriv
  • 26
  • 6
0
votes
0 answers

Error During anonymization DB postgres using dataDefender

After analyze my db using DataDefender and during i anonymized it ,i faced an exception ! you can find the error description below: Desktop\DataDefender\sample_projects\database_discovery\postgresql>java -jar datadefender.jar anonymize…
Eren
  • 11
  • 3
0
votes
1 answer

anonymize rdbms datas, keeping key relations

Is there a "ready-to-use" method to anonymize datas, but keeping relations between keys ? For example, I have : Table #1 user code zip code ztxp15 45789 And : Table #2 user code order date ztxp15 2021-06-27 06:22pm I want…
Sebastien
  • 115
  • 1
  • 11
0
votes
1 answer

Anomynizing first_name, last_name and full_name columns by replacing it with pronunciable english words in a dataframe Spark Scala

I am trying to anonymize the production data with human readable replacements - this will not only mask the actual data but also will give it a callable identity for recognition. Please help me on how to anonymize the dataframe columns like…
0
votes
0 answers

Anonymize sales and other data in MS SQL

I need to anonymize some data from our production server so that I can review the data for further business opportunities. For example, I use the Adventureworks database. Let's say I have the data as in the table below and I have to anonymize it…
Roman Schmidt
  • 55
  • 1
  • 12
0
votes
0 answers

Create a hashed string using a cipher code to anonymize a data?

Say I have a text file with following data: Name Year John Scully 1966 Alex Klaus 1961 .... .... Is there an algorithm or method where I can pass the concatenated first and last name, using birth year as a cipher code to generate an encrypted…
everestial007
  • 6,665
  • 7
  • 32
  • 72