Skip to content
English
Sign in
Go to safetynetsolutions.co.uk
  • There are no suggestions because the search field is empty.

GDPR Data Redaction - Viewing Total Users & Managing Redaction Block Settings.

You want to run GDPR redaction rules but don't see a change in data? You need to update the Redaction block in the database.

This needs to be carried out by someone competent to run a SQL update query, who also has permission to access the server data. If you do not have these permissions or skills then you must set a Hubspot task and allocate to Lisa Alderson-Scott [internal users]. Please send an email or Teams msg to helpdesk@safetynetsolutions.co.uk [external users].

Internal users refer to https://www.loom.com/share/0768f54cc91745fb84f6ddfd97be0964

To see how many users a database is holding, find the users table - selecting top 1000 rows.

Execute this SQL command to display all users contained on the database:

SELECT * FROM tablename;

Every user should now be listed, you can see how many are registered to that database by looking at the bottom right of the table and referring to ROWS: Number

_____________________________________________________________________________

Changing the redaction setting in the DatabaseSetting table: 

UPDATE [databasename].[dbo].[DatabaseSetting]
  SET Value = '-1'
  WHERE setting = 'GDPRRedactionBlocked';

_____________________________________________________________________________

For Reference, -1 is the correct setting for larger databases.

'0' is run but may be blocked if there is large redaction above the redaction limit.

'1' is do not run.

'-1' is run regardless of the volume of records.

This command can also be used to change DB settings. Using this framework, you can amend the database name, value, and setting ID to the property you would like to change.