Skip to main content
Skip table of contents

10.2.0 ~ 10.2.7

QueryPie 10.2.7 Release 

Improvement

  • [General] Added Workflow Request notification items delivered via Slack DM.

  • [Syslog] Added 'Urgent Mode' field to the Legacy Syslog format.

  • [Syslog] Added 'Urgent Mode' field when transmitting Workflow New Request events.

Bug Fix

  • [DAC] Added support for Redshift Connector package.

  • [SAC] Fixed memory leak issue when detecting Windows server agent processes.

  • [Multi-Agent] Enabled registration of hosts using IP addresses and HTTP domains.

  • [Multi-Agent] Resolved memory shortage issue and added automatic recovery functionality.

  • [Agent] Fixed intermittent agent termination issue upon incorrect RDP password entry.

QueryPie 10.2.6 Release 

New Feature

  • [DAC] Support for Custom Data Source (Endpoint Proxy)

  • [SAC] New support for VNC protocol

  • [DAC] New vendor support: Teradata

  • [DAC] Beta release of Tag-based DB Policy Template

  • [SAC] Hourly-based privilege escalation request and approval for server access

Improvement

  • [General] Improved Slack integration (replacing existing Slack DM)

  • [General] Changed Action Rate Limit criteria to IP and Access Token combination

  • [General] Improved multi-selection UI for SQL types in Query Audit logs

  • [General] Applied UTF-8(BOM) encoding when generating report CSV files

  • [General] Limited duplicate actions within the same Workflow request

  • [Agent] Quick connection support for Database 3rd-party clients in multi-agent setups

  • [DAC] Added SID info to Proxy Info on Oracle user connection page

  • [DAC] Enabled SSH for Dr.Sum

  • [SAC] Added automatic tagging feature during Cloud Provider synchronization

  • [SAC] Enabled Agent installation and connection on Rocky Linux 9

  • [SAC] Improved loading speed of Server Groups and Servers lists when assigning server permissions

  • [WAC] Added Web App Configurations page

  • [WAC] Added custom watermark text feature for Web App

  • [WAC] Enhanced accuracy of Web App User Event Logs

  • [AIDD] Added timeout option to Discovery Job for time-limited execution

Bug Fix

  • [Agent] Fixed intermittent 'SecretString' issue

  • [DAC] Fixed issue with PostgreSQL UNION statements referencing tables in WITH clauses

  • [DAC] Fixed MSSQL date display issue in 12-hour format

  • [Workflow] Fixed issue related to Access Control Logs when rejecting DB Access Requests

QueryPie 10.2.5 Release 

New Features

  • [Agent] MVP release of Multi-Agent

  • [SAC] Support for SFTP client Filezilla in QueryPie Agent

  • [SAC] Addition of SSH client x-shell in QueryPie Agent

  • [SAC] External API development for creating/modifying/deleting Policies and adding/removing Policies to/from Roles

Improvements

  • [DAC] Improved exception handling when users press the cancel button during the BigQuery OAuth login process

  • [DAC] Support for Redis Enterprise

  • [SAC] Improved ability to ignore consecutive Enter keys in logs

  • [SAC] Support for AD account login on RDP Windows Server

Bug Fixes

  • [DAC] Improved policy application to the Ledger table only when it is the actual target table during ledger table identification

  • [DAC] Fixed issue with identifying the Ledger in the target table for INSERT operations

  • [DAC] Resolved issue with SQL Server Availability Group dashboard usage

  • [DAC] Fixed memory overload issue when running large queries after enabling DML Snapshot option

  • [DAC] Resolved query execution error after setting SQL Server options such as SET STATISTICS IO, TIME

  • [Workflow] Fixed issue where approval failed for approval requests that included deleted connections

QueryPie 10.2.4 Release 

New Features

  • [DAC] Added support for new vendor Spanner.

  • [DAC] Added support for new vendor Dr.Sum.

  • [DAC] Added OAuth authentication support when connecting to BigQuery.

  • [KAC] Added reverse tunnel support for Kubernetes clusters (NOVA).

  • [SAC] Added external API support for Cloud Provider registration, editing, and deletion.

  • [Workflow] Added external API support for user SQL request submission and execution.

Improvements

  • [General] Added Indonesia time zone support.

  • [General] Improved to use UTF-8 (BOM) encoding when creating CSV files.

  • [DAC] Enhanced normal operation of personal Keytab and UID & PW authentication in workflow.

  • [DAC] Improved account information handling for SQL request execution: retry functionality added for incorrect information.

  • [DAC] Improved synchronization for instances without Public IP or Private IP when working with Cloud SQL.

  • [DAC] Enhanced SQL History panel in the web editor to sort "Executed At" entries in reverse order.

  • [DAC] Improved registration logic for Athena Workgroup.

  • [DAC] Enhanced database filter operation when synchronizing with GCP.

  • [SAC] Added HA configuration and PPv2 support for NOVA Server.

  • [AIDD] Added SSL support for all supported databases.

  • [SAC] Improved UX for Select All Checkbox when selecting servers.

  • [SAC] Improved server access permissions to allow unlimited expiration dates.

  • [SAC] Enhanced bulk granting of server permissions (Direct Permission) on a large scale.

  • [SAC] Added the ability to edit non-server items on the Server Group edit page.

  • [SAC] Added multi-hop support for ProxyJump.

  • [Audit] Added an option to truncate characters when exporting Audit Logs.

  • [WAC] Improved sub-path registration when creating a WebApp.

  • [WAC] Enhanced access control logic for Single Page Applications.

  • [WAC] Added functionality to download RootCA certificates.

  • [DAC] Enhanced masking policy scanning logic when connecting to a database.

  • [DAC] After executing DML queries for Ledger, added functionality to redirect using a custom link when passing workflows.

Bug Fixes

  • [Workflow] Fixed an issue where the All Requests menu was not visible with Full Access Policy permission.

  • [DAC] Resolved errors related to target table loading during CSV imports.

  • [DAC] Fixed execution errors for UPDATE, DELETE, and MERGE statements containing SQLServer WITH clauses.

  • [DAC] Resolved issues where queries failed to import data properly from Oracle.

  • [DAC] Fixed display-related issues with ORDER BY in SELECT statements.

  • [DAC] Addressed a problem where Role ARN and related fields were not displayed correctly when saving AWS synchronization information.

  • [DAC] Fixed the “This user does not exist anymore” error when synchronizing from a Cloud Provider.

QueryPie 10.2.3 Release 

 

Bug Fix

  • [AIDD] Fixed the issue where specific DB data paths overlap, preventing hash duplication, and ensured that Discovery Jobs operate correctly

QueryPie 10.2.2 Release 

New Feature

  • [WAC] Released Web Access Controller MVP version

  • [DAC] Added support for new vendor OpenSearch

  • [General] Added Email Notification feature

Improvement

  • [Agent] Improved the upgrade process to explicitly require obtaining administrator privileges before proceeding

  • [Agent] Added support for SQLGate Quick Connection in Windows Agent

  • [AIDD] Enhanced user dashboard and improved scan performance

  • [DAC] Added an environment variable to allow masked columns to be used in WHERE conditions

  • [DAC] Added support for Athena Ledger Tables

  • [DAC] Added Export Purpose functionality to Ledger policies

  • [DAC] Provided fixed/random password options for Oracle, MongoDB, and PostgreSQL Proxy (Agent)

  • [SAC] Improved functionality to allow connections to Windows Server without an RDP Server Agent

  • [SAC] Enhanced Allow/Deny specifications in Command Template

  • [SAC] Added support for OpenSSH Certificates

  • [SAC] Added mapping functionality between Windows Server and existing Windows OS after installing Server Agent

  • [SAC] Added Vault SSH CA Engine for signed SSH certificates

  • [SAC] Supported external APIs for Server Access Control Role permissions

  • [SAC] Provided an option to maintain open sessions when policies are changed

  • [KAC] Improved tips for policy syntax changes

  • [KAC] Enhanced policies for non-namespaced resources

  • [KAC] Added Request Audit-related logs to Alert types

  • [General] Updated Alert feature UI/UX and improved condition selection options

  • [General] Improved cloud provider synchronization by enabling key-based storage for reuse and synchronization

Bug Fix

  • [DAC] Resolved cursor position issue when writing queries in the web editor on Windows environments

  • [SAC] Resolved an issue where TELNET and FTP protocols were not visible to regular users

QueryPie 10.2.1 Release 

 

New Feature

  • [Admin] Added Proxy Throttling feature

  • [DAC] Supported BigQuery policies

  • [DAC] Added support for new vendor Vertica

  • [DAC] Enabled MariaDB ledger functionality

  • [DAC] Added Ledger table management feature

  • [SAC] Supported Reverse Tunneling Agent functionality for server connections (NOVA)

Improvement

  • [Admin] Improved Integrated Reporting functionality

  • [Admin] Segmented admin privileges for User Management

  • [Admin] Added Name selection for LDAP integration under Authentication

  • [DAC] Enhanced log display for rules set using regular expressions for Sensitive Data

  • [DAC] Improved Access Control UI/UX

  • [DAC] Added expiration date specification when granting DB permissions from the admin page

  • [DAC] Added Ledger functionality API

  • [DAC] Improved masking policy to allow rule application on multiple columns

  • [DAC] Supported MySQL 8.0 JSON Table Function

  • [DAC] Improved Oracle OCI connection to allow use of individual DB accounts and logging

  • [SAC] Advanced command bypass control (Command Restrictions)

  • [SAC] Added Allow / Deny specification for Command Template settings

  • [SAC] Supported additional JumpHost SSH Key algorithms when using ProxyJump

  • [KAC] Supported Test Connection feature on the EKS cluster detail page

QueryPie 10.2.0 Release 

 

New Feature

  • [General] Added multi-language global configuration

  • [General] Added user password security rule settings

  • [DAC] Supported Hive data policies (Data Access, Data Masking, Sensitive Data)

  • [SAC] Added support for OTP engine types when integrated with Vault

  • [Workflow] Added an Unmasking Request feature for masking removal requests

  • [Workflow] Supported execution plan functionality in SQL Requests

Improvement

  • [General] Added Message Template Variables (workflowUuid, urgent, executedAt) in Alerts

  • [General] Updated job execution and result processing to handle success/failure per individual item rather than globally

  • [IDP] Masked API token values for Okta Sync

  • [IDP] Added a Dry Run feature for Okta, Onelogin, and LDAP synchronization

  • [DAC] Enabled a Dry Run feature for cloud synchronization

  • [DAC] Added a search feature on the Policy Detail page

  • [DAC] Supported Ed25519 password encryption for MariaDB

  • [DAC] Added Primary Key support in DML Snapshot for UPDATE queries

  • [DAC] Added tooltips for connection name and host in the connection popup in the web editor

  • [DAC] Increased the maximum character limit for reason input fields to 300

  • [DAC] Fixed display errors on the connection detail page for permissions handled as long-term inactive

  • [DAC] Adjusted MySQL Prepared Statements to log parameter information in the Audit

  • [SAC] Applied terminal color themes per server

  • [SAC] Added Test Connections feature for individual servers within Server Groups

  • [SAC] Allowed port number specification during server synchronization

  • [Audit] Enabled KAC Audit Log export functionality

  • [Audit] Added multi-select functionality for SQL Type filters in the Query Audit menu

  • [Workflow] Supported External API for user-specific approvals

  • [Agent] Enhanced the Host input process to navigate directly to the web login page

  • [AIDD] Added an AI classifier

  • [AIDD] Improved false positive handling, stability, and added a dashboard widget

Bug Fix

  • [General] Resolved issue where users were logged out before reaching session timeout threshold

  • [General] Fixed issue where resetting the password failed for accounts with User Admin Role policy

  • [DAC] Fixed issue where NewLine characters were not displayed when querying or modifying grids

  • [DAC] Resolved issue where Materialized Views could not be queried when applying QSI to PostgreSQL

  • [SAC] Fixed issue where "Server Group not found" error occurred when deleted servers existed

  • [DAC] Resolved issue where queries executed normally on MongoDB via Agent were logged as "Stopped"

  • [DAC] Fixed issue where DB Access History showed "Failure" when MongoDB connection via Agent was successful

  • [DAC] Resolved issue where the USE statement failed for databases starting with numbers on some vendors

  • [DAC] Fixed error where synchronization failed due to exceptions when there were no permissions on specific resources

  • [DAC] Resolved issue where Oracle Proxy did not function correctly when identical BLOB data existed

  • [DAC] Fixed issue where Proxy connection was intermittently terminated when Oracle usage was high

  • [DAC] Updated AWS cloud synchronization to skip instances in Modifying state

  • [DAC] Fixed Unauthorized error when querying Oracle after Agent connection

  • [Audit] Resolved issue where multiple logout logs were generated during session timeout

  • [Audit] Addressed memory issue when exporting logs with large Query Full Text content

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.