1. CREATE SESSION

Use: Fundamental system privilege that allows a user to log in (connect) to the Oracle database.
Why is it required?: To connect to the database (DBeaver, SQL Developer, OLake, etc.).
Grant Query:

    GRANT CREATE SESSION TO <username>;

---

2. SELECT ON <table>

Use: Grants read-only access to run SELECT queries on the table owned by the schema owner.
Why is it required?: Required to access the table for discovery and chunk iteration.
Grant Query:

    GRANT SELECT ON <table_owner>.<table_name> TO <username>;

---