Use caseOracle database firewall

Stop risky SQL before it reaches Oracle

SWOT DAM includes a database firewall, its SQL Gateway. It sits between your applications and Oracle 19c, 21c or 23ai and decides every statement against policy before it runs, with nothing installed on the database. A blocked statement returns the database’s own policy error; the session stays open.

Book a demoSee it work

Oracle limits to know before a pilot

  1. 01

    Native Network Encryption is refused

    Logins that use Oracle Native Network Encryption are refused. Use TCPS (TLS) for gateway connections.

  2. 02

    Listener REDIRECT is refused

    A listener redirect refuses the connection. Point the gateway at the serving instance or SCAN address.

  3. 03

    Result-size limits count bytes

    Oracle result-size limits count bytes, not rows, so express them in bytes. A blocked result-size limit closes the session: use ALERT instead of BLOCK.

See it work

One query, two views

Pick a query from a sample session and see what is stopped before it reaches the database, and what SWOT DAM sees inside.

Sample session by db_support on Billing PostgreSQL.

SWOT PAM · at the door

Connected as

pam_tmp_db_support_8c1 temporary, removed on disconnect

Verdict

SWOT DAM · inside

Audit record

Sensitive columns

    Identity risk

    How it works

    How the Oracle gateway works

    1. Point clients at the gateway

      Applications and tools connect to the SQL Gateway instead of the database. Verified end to end on Oracle 19c, 21c and 23ai: JDBC (ojdbc8 to 17), SQL Developer 26.2, UCP, HikariCP, OCI, python-oracledb, DRCP and 23ai pipelining. For drivers or versions not listed, pilot first.

    2. Decide every statement

      Single, batch, array, re-executed and 23ai pipelined statements are all decided against policy. Rules match on user, source IP, sensitive tables, statement type and risk score.

      SWOT DAM
    3. Block the statement, keep the session

      A blocked statement returns the database’s own policy error and the session stays open, so applications keep working. Traffic the gateway cannot read is refused, never passed on.

    4. Monitor through Unified Audit

      SWOT DAM collectors read Oracle Unified Audit, the database’s own audit trail, and score each identity against its own 30-day baseline.

      SWOT DAM

    Questions

    Related

    Does SWOT DAM work as an Oracle database firewall with JDBC?

    Yes. Oracle JDBC (ojdbc8 to 17) is verified end to end through the SQL Gateway on Oracle 19c, 21c and 23ai, as are SQL Developer 26.2, UCP, HikariCP, OCI, python-oracledb, DRCP and 23ai pipelining. For drivers or versions not listed, pilot first.

    What does an application see when a statement is blocked?

    The database’s own policy error. The session stays open, so the application keeps working; only the risky statement is stopped.

    Does the gateway work with Oracle Native Network Encryption?

    No. Logins that use Native Network Encryption are refused; use TCPS (TLS) for gateway connections instead. Every other limit is on the SWOT DAM gateway limits page.

    See it on your own systems

    A walk-through of SWOT DAM with the team that builds them.

    Book a demoContact us