Connect Oracle Database
📖 How to SetupRequired Oracle Grants
Create a dedicated read-only Oracle user, then grant it access to performance views.
Step 1: Create the user
-- Create the TuneVault read-only user
-- Replace <your_password> with your chosen password
CREATE USER tunevault_reader IDENTIFIED BY <your_password>
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
-- Grant login privilege
GRANT CREATE SESSION TO tunevault_reader;
Step 2: Grant read access (choose one option)
Option 1: Simple (full catalog read)
GRANT SELECT_CATALOG_ROLE TO tunevault_reader;
Option 2: Minimum grants
-- Instance & database info
GRANT SELECT ON V_$INSTANCE TO tunevault_reader;
GRANT SELECT ON V_$DATABASE TO tunevault_reader;
GRANT SELECT ON V_$PARAMETER TO tunevault_reader;
GRANT SELECT ON V_$VERSION TO tunevault_reader;
-- Performance data
GRANT SELECT ON V_$SQL TO tunevault_reader;
GRANT SELECT ON V_$SYSTEM_EVENT TO tunevault_reader;
GRANT SELECT ON V_$SYSSTAT TO tunevault_reader;
GRANT SELECT ON V_$LIBRARYCACHE TO tunevault_reader;
GRANT SELECT ON V_$ROWCACHE TO tunevault_reader;
GRANT SELECT ON V_$OSSTAT TO tunevault_reader;
-- Memory
GRANT SELECT ON V_$SGA TO tunevault_reader;
GRANT SELECT ON V_$SGASTAT TO tunevault_reader;
GRANT SELECT ON V_$PGASTAT TO tunevault_reader;
GRANT SELECT ON V_$SQL_WORKAREA_HISTOGRAM TO tunevault_reader;
-- Tablespace & storage
GRANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO tunevault_reader;
GRANT SELECT ON DBA_TABLESPACES TO tunevault_reader;
GRANT SELECT ON DBA_DATA_FILES TO tunevault_reader;
GRANT SELECT ON DBA_FREE_SPACE TO tunevault_reader;
-- Index analysis
GRANT SELECT ON DBA_INDEXES TO tunevault_reader;
GRANT SELECT ON DBA_IND_STATISTICS TO tunevault_reader;