DATPROF Privacy requires:
Microsoft Windows 7 or higher or Microsoft Windows server 2012 or higher.
.NET Framework 4.8
The user installing the software should have the permission to install software.
CPU: x86 1GHZ or higher.
Memory: at least 4GB RAM.
Diskspace: at least 1GB.
DATPROF adheres to the software lifecycle of the database vendors.
Version 11.2 and above
Microsoft SQL Server
Version 2008 (not for Runtime)
10.5 and above
DB2 for i
DB2 for z/OS
13.0 and above
9.5 and above
Not applicable - SaaS solution.
*Check the Powershell module remarks
Permissions and Roles
If the Privacy User is the TABLE_OWNER
Minimum System Privileges
Minimum Object privileges
EXECUTE permission on dbms_random package
EXECUTE permission on dbms_metadata package
If the Privacy User is not the same as the TABLE_OWNER these additional permissions are required:
SELECT on the tables to mask
REFERENCES on the tables to mask
ALTER on the tables to mask
CREATE ANY INDEX
DROP ANY INDEX
CREATE ANY TABLE
INSERT ANY TABLE
When you have created your own procedure(s)/function(s), use sequences or reference views in your scripts, you should take care to grant the Privacy user the right permissions.
Microsoft Sql Server
The user masking the database should have dbo permissions in the database targeted for data masking.
Powershell module dependency
To retrieve DDL information from Microsoft SQL Server, Datprof Runtime uses a PowerShell module.
In time Microsoft has replaced the original "SQLPS" module by the "SqlServer" module.
As of version 4.0 the SqlServer module is delivered with Privacy and does not need to be installed manually.
For this, Microsoft PowerShell version 5 or higher is required.
Open a Powershell window on your system "as administrator"
Check the Powershell version: $psversiontable.Psversion
If the major version is lower than 5 upgrade your Powershell by downloading/installing "Windows Management Framework" version 5.x.
When using Runtime on a Linux system, PowerShell must be installed and also the "SqlServer" module needs to be installed manually.
For installing PowerShell on a Linux system see the Microsoft documentation: https://docs.microsoft.com/nl-nl/powershell/scripting/install/installing-powershell-core-on-linux .
To install the required Sqlserver module execute this:
Open a PowerShell window on your system, either as the user running Runtime or as root
Install the module with the command: Install-Module -Name SqlServer
To use DATPROF Privacy for Linux, Unix, Windows (LUW) the following IBM software is required on the client PC: IBM DB2 Data server driver package.
After installation DATPROF Privacy will use the 32bit dll’s in the subfolders netf40 or netf40_32.
The user masking the database should have connect, dataaccess, createtab permissions in the database targeted for data masking.
You should have the IBM i Access for Windows 7.1 or IBM i Access Client Solutions installed. This software is available on the IBM site.
The user masking the database should have DBADM permissions in the database schema targeted for data masking.
DB2 for z/OS (Mainframe)
In order to use Subset with DB2 for z/OS databases, the user must possess their own db2jcc_license_cisuz.jar file - This is the IBM Data Server for JDBC and SQLJ license file that allows access to the database through the JDBC protocol. This is a separate license that must be acquired through IBM. This file must then be placed in the Drivers sub-folder of the Privacy installation folder. If this is not done, the user is greeted by the following error upon trying to test a connection to the database:
The user masking the database requires admin level permissions in the database.
The user masking the database should have admin level permissions in the database targeted for data masking.
PostgreSQL, MySQL and MariaDB
You should at least have select permissions on the tables to import.
To execute a scenario database owner permissions are required.