Oracle

-- Only needed for multitenant (CDB/PDB) setups. Skip if you use a single-tenant database.
-- Replace YOURPDB with the name of your pluggable database (e.g., XEPDB1).
ALTER SESSION SET CONTAINER = YOURPDB;

CREATE USER DATAFOLD IDENTIFIED BY <your_secure_password>;

-- Allow Datafold to connect to the database
GRANT CREATE SESSION TO DATAFOLD;

-- Allow Datafold to create temporary working tables and views in its own schema
GRANT CREATE TABLE TO DATAFOLD;
GRANT CREATE VIEW TO DATAFOLD;

GRANT SELECT ANY TABLE TO DATAFOLD;

BEGIN
  FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'YOURSCHEMA') LOOP
    EXECUTE IMMEDIATE 'GRANT SELECT ON "YOURSCHEMA"."' || t.table_name || '" TO DATAFOLD';
  END LOOP;
END;
/

GRANT UNLIMITED TABLESPACE TO DATAFOLD;

-- Example: allow up to 1 GB on a specific tablespace
ALTER USER DATAFOLD QUOTA 1G ON <tablespace_name>;

----------------------------------------------------------------------
-- Datafold Oracle setup script
-- Run as a DBA or user with GRANT privileges
----------------------------------------------------------------------

-- Step 1: Switch to your pluggable database (multitenant only — skip if single-tenant)
-- ALTER SESSION SET CONTAINER = YOURPDB;

-- Step 2: Create the Datafold user
CREATE USER DATAFOLD IDENTIFIED BY <your_secure_password>;
GRANT CREATE SESSION TO DATAFOLD;
GRANT CREATE TABLE TO DATAFOLD;
GRANT CREATE VIEW TO DATAFOLD;

-- Step 3: Grant read access (choose Option A or Option B)

-- Option A: Access to all tables (simplest)
GRANT SELECT ANY TABLE TO DATAFOLD;

-- Option B: Access to specific schemas only (repeat per schema)
-- BEGIN
--   FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'YOURSCHEMA') LOOP
--     EXECUTE IMMEDIATE 'GRANT SELECT ON "YOURSCHEMA"."' || t.table_name || '" TO DATAFOLD';
--   END LOOP;
-- END;
-- /

-- Step 4: Required system privileges
GRANT UNLIMITED TABLESPACE TO DATAFOLD;

-- Or, to cap disk usage:
-- ALTER USER DATAFOLD QUOTA 1G ON <tablespace_name>;

ALTER USER DATAFOLD ACCOUNT UNLOCK;