Deep Data Protection: Advanced Database Audit & SQL Control in RankEZ

Key Scenarios Showcased in the Demo

• Granular Policy Configuration

  Watch an administrator easily define a "Database Policy" that extends access control all the way down to the database, table, and row levels. The demo shows setting specific rules, such as "Deny" for create or update commands, and "Filter" for select statements on sensitive tables.

• Preventing Accidental Data Loss

  See a scenario where a developer uses RankEZ's HTML5 web terminal to access a database. When they accidentally or maliciously attempt to execute an unauthorized command (like dropping a table), RankEZ instantly intercepts and blocks the action, triggering an alert to stakeholders and preventing catastrophic data loss.

• Dynamic Data Masking & Filtering

  The demo highlights RankEZ's advanced data retrieval controls. Watch a user execute a valid SELECT query, but because of the configured policy, the returned results are dynamically masked or filtered (e.g., limiting the number of rows or columns returned), ensuring sensitive data remains hidden from unauthorized eyes.

• Deep SQL Auditing & Forensics

  Finally, navigate to the auditor's dashboard. Instead of just providing a video recording, RankEZ meticulously captures the exact SQL statements executed in plaintext. The demo shows how auditors can review the precise inputs and outputs of the database session, making compliance and forensic tracking incredibly straightforward.