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