9.19.0 ​

QueryPie 9.19.0 Release 

2024. 6. 3.

New Features

• [SCIM] Support for user and group provisioning based on SCIM 2.0

• [Users] Support for managing user attribute profiles

• [Integrations] New Integrations menu for connecting with security tools like SIEM and SOAR

• [DAC] Added support for new vendor SingleStore

• [DAC] Added support for new vendor SAP HanaDB

Enhancement

• [Workflow] Added support for multi-query submissions in SQL Export Request

• [Workflow] Added feature to designate Server Group Owner as an approver in Approval Rule settings

• [Ledger] Added admin on/off option for justification input settings

• [Ledger] Added option to reuse justification input text

• [Ledger] Added support for vendor Oracle

• [SAC] Added support for Linux for the Agent

• [SAC] Added Visual Mode support in the Policy Editor

• [SAC] Added feature to designate Server Group Owner within server groups

• [ABAC] Added support for defining policy constraints based on user attributes

Bug Fix

• [DAC] [Postgres] Resolved issue where AWS Lambda function calls would fail

• [DAC] [Postgres] Fixed error occurring when executing the decode function

• [DAC] [MySQL] Fixed encoding error occurring when BLOB INSERTing via Proxy

• [DAC] [MySQL] Resolved error occurring when BLOB INSERTing with DML Snapshot enabled

External API

• Added new V2 APIs and improved some API query parameters:

  • List Servers (filter by server name)

  • Server Group Owners API (list/assign/unassign server group owners)

  • Server Groups API

    • List Group Servers (filter by server group name)

    • Override group filter tag conditions

    • Add/remove servers in server groups

  • User Management API (create/list/delete users)

  • User Group Management API (create/list/delete user groups)

  • Group Member Operations API (list/add/remove group memberships)

  • Workflow - System Access Request Details (view details of server access request workflows)

• Changed some API specifications - Removed the “deleted” field:

  • List Users (/api/external/v2/users)

  • Get User (/api/external/v2/users/{userUuid})

  • List DB Cloud Providers (/api/external/v2/dac/cloud-providers)

  • List DB Connections (/api/external/v2/dac/connections)

  • Get DB Connection (/api/external/v2/dac/connections/{dbConnectionUuid})

  • List Privileges (/api/external/v2/privileges)

  • Get Privilege (/api/external/v2/privileges/{uuid})