🐍 Enterprise IT Python Tools

Oracle Security Scanner

DB Realm Inc. (Internal)

Challenge

Database teams needed a comprehensive, automated security assessment tool that evaluates Oracle databases against industry best practices and compliance frameworks without requiring expensive commercial tools.

Solution

Built a Python application with a Flet-based GUI that executes 355+ security checks across categories including user privileges, network configuration, audit settings, encryption, and patching. Generates detailed HTML reports with remediation recommendations.

Results

  • ✓ 355+ automated security checks across 19 categories
  • ✓ Cross-platform Flet GUI
  • ✓ HTML reports with remediation guidance
  • ✓ Deployable across Oracle 11g–23ai
Python Oracle Security Flet GUI 355+ Checks Compliance

The Oracle Security Scanner is a comprehensive audit tool that goes far beyond basic checks. It evaluates password policies, privilege escalation risks, network exposure, audit configuration, encryption status, and dozens more categories — generating actionable reports that DBAs can use to harden their environments.

More Python Tools Projects

Oracle Database Monitoring at Fleet Scale

Monitoring an Oracle estate usually forces a bad trade. Agent-based tools need software installed on database servers, which security teams resist and change control slows down. Console-based tools cost more than the databases they watch. And most of them quietly read Diagnostics Pack views, exposing the organization to a licensing claim that only surfaces during an audit — long after the usage is logged.

Financial Tax Report Generator

Needed to automate the generation of complex Canadian tax reports with 9 worksheets covering income categorization, HST/GST calculations, expense breakdowns, and annual summaries.

Database Verification Framework

After database migrations and upgrades, teams needed a systematic way to verify data integrity, schema correctness, and application readiness across 120+ validation points.

Ready to Build Something Similar?

Let's discuss how we can bring the same expertise to your organization.

Start a Conversation