Perform the following steps to create a masking connection for different databases in RDBMS:
Select the Location and IDP Type i.e., Masking.
Select the database from the left side pane.
The below list displays the list of all the supported data sources in RDBMS:
*Note: Dynamic Masking is supported for the following databases: Oracle, SQL server, and MySQL. To know dynamic masking process in detail, refer to Dynamic Masking Configuration.
Click the Test button to test the connection i.e., to check whether it is successfully established or not.
Click Test & Validate, to check if the intended user has grants to mask the records of target database. In case, if user do not have rights, then click Test & Validate option. The Validate Grants screen pop-ups, which displays the set of commands that user needs to execute.
There are two ways in which you can provide grants to a specific masking user, perform the following steps:
Copy to Clipboard – Click the button to copy the grant and execute it in the database editor.
Execute & Save – Click the button to execute the grant on PK Protect and Save it.
In both the option, enter the following information:
Enter the username in Admin Username and password in Admin Password of the target database.
Enter the Default and Temporary Tablespace name in the given fields. The field name changes based on the type of the connection created.
Edit a connection in RDBMS
To edit a connection in RDBMS, perform the following steps:
Go to RDBMS > Connection Manager > Connection List. Select the connection classification type from the Select Group drop-down.
Select the connection.
Click the Pen icon under the Action column to edit the connection details.