9.19.0
QueryPie 9.19.0 Release
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}
)