Reference Guide
...
SQL Proxy
Dynamic Data Masking

Oracle RAC Configuration

1min

Enabling Auto Registration: To enable automatic registration of RAC device definitions by SQLProxy, you need to set the following parameter in the system configuration manager:

Parameter Name

Parameter Value

sql.proxy.node.auto.register.enabled

yes

Steps to enable auto registration in system config manager
Steps to enable auto registration in system config manager


Adding Oracle RAC Database to KRON PAM: Follow the standard procedure to add the Oracle RAC database to KRON PAM: • Navigate to Device Add. • Assign the device to a Device Group. • Add a user under User add. • Assign the user to a User group. • Define a Policy Key. • Set up a Mask Policy. • Group the policies under Policy Group. • Finally, assign the device to a Realm.

Configuring Database Properties: Once the Oracle RAC database is added to KRON PAM, you need to specify its properties. Follow the standard procedure to add the properties.

Configuring RAC database properties in KRON PAM
Configuring RAC database properties in KRON PAM


Connecting to RAC Database via SQL Client in KRON PAM: When you attempt to connect to the RAC database inside KRON PAM using an SQL client, KRON PAM will automatically detect all the databases within that cluster.

Only 42.77 configurated and 42.75 – 42.76 automatically added by Kron PAM
Only 42.77 configurated and 42.75 – 42.76 automatically added by Kron PAM