Skip to content

Disable Access Control

Use this setting when you want Privacera to handle data masking only, and you want access control (access management) completely disabled.

When this property is enabled:

  • Access management is fully disabled for the MSSQL connector.
  • PolicySync loads only masking-related ACLs and does not load access-control ACLs.
  • Any access policy you create in the Privacera portal will not work — it will not grant permissions in Microsoft SQL Server.
  • Access control must be managed by an external system; Privacera continues to synchronize and apply masking policies.

Default value: false (access-control ACLs are loaded and portal access policies work as usual).

Set to false (or omit the property) to keep access control enabled.

Setup

  1. SSH to the instance where Privacera Manager is installed.

  2. Open the connector variables file:

    If you have multiple connectors, replace instance1 with the appropriate connector instance name.

    Bash
    1
    vi ~/privacera/privacera-manager/config/custom-vars/connectors/mssql/instance1/vars.connector.mssql.yml

  3. Add or update the property to disable access control:

    YAML
    1
    CONNECTOR_MSSQL_PERMISSION_LOADER_LOAD_ONLY_MASKING_ACLS: "true"

  4. Run the following commands to update your Privacera Manager platform instance:

    Step 1 - Setup which generates the helm charts. This step usually takes few minutes.

    Bash
    1
2
    cd ~/privacera/privacera-manager
./privacera-manager.sh setup
    Step 2 - Apply the Privacera Manager helm charts.
    Bash
    1
2
    cd ~/privacera/privacera-manager
./pm_with_helm.sh upgrade
    Step 3 - (Optional) Post-installation step which generates Plugin tar ball, updates Route 53 DNS and so on. This step is not required if you are updating only connector properties.

    Bash
    1
2
    cd ~/privacera/privacera-manager
./privacera-manager.sh post-install

  1. In the PrivaceraCloud portal, go to Settings → Applications.

  2. On Connected Applications, select MSSQL and open the application for edit.

  3. Go to Access Management → ADVANCED.

  4. Under Add New Custom Properties, add (replace 0 with your connector index if needed):

    Properties
    1
    ranger.policysync.connector.0.permission.loader.load.only.masking.acls=true

  5. Select SAVE to apply the changes.