Skip to content
Wharfbase

Oracle Database

Oracle Database databases are found in containers by their image.

Plan Pro and Team
Default ports 1521
Credential hints from APP_USER, APP_USER_PASSWORD, ORACLE_PASSWORD, ORACLE_PWD, ORACLE_DATABASE
Data in the container /opt/oracle/oradata

Browse tables and views of your schemas, the SQL editor with Explain (DBMS_XPLAN), exports. Read-only scripts run under SET TRANSACTION READ ONLY, with inline PL/SQL refused.

Wharfbase works with any user; give it only what you want it to do.

CREATE USER wharfbase_ro IDENTIFIED BY "…";
GRANT CREATE SESSION TO wharfbase_ro;
GRANT READ ON app.customers TO wharfbase_ro; -- per table, or:
GRANT READ ANY TABLE TO wharfbase_ro;

Grant SELECT, INSERT, UPDATE, DELETE on the tables instead of READ.

Functions with PRAGMA AUTONOMOUS_TRANSACTION can write even from a read-only transaction: a user with READ grants only is the hard guarantee.