Oracle

Search…

Oracle

Below you will find details on how to create a tonic user on both the source and destination databases with the minimum level of permissions needed for Tonic to function.
Source Database
The source destination user can be the same as the schema of the data, however it is recommended to create a tonic-specific user with more restricted/read-only access.
1
--create a user
2
CREATE USER 'tonic' IDENTIFIED BY 'tonic_password';
3
​
4
--give the user access to connect and export
5
GRANT CREATE SESSION, EXP_FULL_DATABASE TO TONIC;
6
​
7
--give the user access to tables in your preferred schema
8
BEGIN
9
    FOR x IN (SELECT owner, table_name FROM all_tables WHERE owner = '<source_schema>')
10
    LOOP
11
        EXECUTE IMMEDIATE 'GRANT SELECT ON "' || x.owner || '"."' || x.table_name || '" to TONIC';
12
    END LOOP;
13
END;
Copied!
Destination Database
1.
The user used for connecting to the destination database cannot be the same user as the output schema of the data.
2.
Tonic creates the schema in the output, but does not create the tablespace. Tablespace(s) must be created first.
1
--create a new user
2
CREATE USER 'tonic' IDENTIFIED BY 'tonic_password';
3
​
4
--This user must be granted more extensive privileges
5
GRANT ALL PRIVILEGES, IMP_FULL_DATABASE to TONIC;
Copied!
​

Database Specific Setup - Previous

Google BigQuery

Next - Database Specific Setup

Snowflake on AWS

Last modified 19d ago

Copy link

Contents

Source Database

Destination Database