CREATE USER 'tonic' IDENTIFIED BY 'tonic_password';
--give the user access to connect and export
GRANT CREATE SESSION, EXP_FULL_DATABASE TO TONIC;
--give the user access to tables in your preferred schema
FOR x IN (SELECT owner, table_name FROM all_tables WHERE owner = '<source_schema>')
EXECUTE IMMEDIATE 'GRANT SELECT ON "' || x.owner || '"."' || x.table_name || '" to TONIC';