%201.png){kind=logo}
10.2.0 ~ 10.2.9
QueryPie 10.2.9 Release
Enhancement
[SAC] Improved to maintain user sessions even when roles are changed or direct permissions are granted.
Bug Fix
[DAC] Fixed an issue where selecting a table with 400 columns via proxy in Impala would fail.
[DAC] Resolved a memory leak issue in MongoDB.
[DAC] Fixed an issue preventing databases with schemas from being requested during Unmasking Requests.
[General] Resolved an issue where enabling SSL for the QueryPie Meta DB resulted in infinite connection attempts.
[General] Fixed an issue where the Endpoint URL for S3-compatible storage MinIO could not be configured.
[General] Resolved an issue preventing the deletion of user groups.
[General] Fixed an issue where approvers were not receiving Slack DMs upon workflow request submission.
[WAC] Resolved an issue of excessive "Invalid Token" debug log output when updating login status.
QueryPie 10.2.8 Release
New Feature
[DAC] New vendor support: ClickHouse
[DAC] Added functionality to disable data masking for specific IP ranges
Enhancement
[General] Added validation checks to Network Zone External API
[General] Improved text copying functionality within Alert Dialog modals
[General] Changed the configuration location of the QUERYPIE_WEB_URL environment variable (moved to Meta DB)
[Agent] Enabled SAC support in multi-agent environments
[Agent] Enabled multi-agent support on Linux OS
[Agent] Expanded functionality of the macOS status menu and tray icon
[DAC] Added support for Temporary Tables in PostgreSQL
[DAC] Enabled reason input modal in multi-agent environments
[DAC] Displayed vendor support level on the DB Connections details page
[DAC] Added support for $search and $searchMeta stages for MongoDB Atlas Search
[DAC] Enhanced logging to include the executed query when a sensitive data access event occurs
[SAC] Added functionality for users to customize the RDP port
[KAC] Added support for dynamic values (User Groups) in the kubernetesGroup field within Policies
[WAC] Added Root CA certificate management feature in Web App Configurations
[WAC] Enhanced Policy functionality with an improved structure and WildCard support
Vulnerability
[General] Implemented mandatory password change and account deletion support for the default qp-admin account
Bug Fix
[General] Fixed an issue where successful logins were included in the login attempt count
[Agent] Resolved inconsistent width of the Host selection dropdown before and after multi-agent login
[DAC] Addressed an unmanaged memory leak issue in PostgreSQL
[DAC] Fixed an issue in PostgreSQL where column information for certain functions was not displayed if the AS clause was missing
[DAC] Improved handling of empty query responses in PostgreSQL
[DAC] Fixed an issue in the SQL Request results tab where results exceeding 1,021 rows were not displayed correctly
[DAC] Resolved a proxy connection failure issue in Impala when querying tables with a large number of columns
[DAC] Fixed an issue where the Default Privilege selection window appeared when an unauthorized user executed a query
[SAC] Fixed an issue in Web Terminal where the history of an existing session tab was not maintained when connecting to a new session
[SAC] Fixed a bug that prevented SSH connections via the Agent in VDI (Windows) environments
[SAC] Resolved a save error that occurred when changing the Secret Store for an existing account
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