Oracle Setup

-- Create the Prizm connection user
CREATE USER prizm_svc IDENTIFIED BY "<password>";
GRANT CREATE SESSION TO prizm_svc;

-- Read access to the data dictionary
GRANT SELECT_CATALOG_ROLE TO prizm_svc;
-- Or, where SELECT_CATALOG_ROLE is restricted:
-- GRANT SELECT ANY DICTIONARY TO prizm_svc;

-- Freshness detection
GRANT SELECT ON SYS.ALL_TAB_MODIFICATIONS TO prizm_svc;

-- Performance and usage metrics
GRANT SELECT ON V_$SQL TO prizm_svc;
GRANT SELECT ON V_$SQLAREA TO prizm_svc;
GRANT SELECT ON V_$SESSION TO prizm_svc;

-- Extended historical performance metrics (only if Diagnostics Pack / AWR is licensed)
GRANT SELECT ON SYS.DBA_HIST_SQLSTAT TO prizm_svc;

-- Quality rule execution (scan-based checks) — grant per schema/table in scope
GRANT SELECT ON <schema>.<table> TO prizm_svc;