Prepare for Oracle integration

Before ingesting Oracle metadata into Dawiso, prepare your account for authentication by configuring an Oracle user and grant it the necessary permissions.

Supported Oracle versions

• Oracle 19c
• All editions

Connection configuration

Dawiso Cloud currently supports traditional authentication method using credentials. You will need a user with required permissions and a password to ingest data from the Oracle service.

Create new user

Create a new user (e.g., dawiso) in Oracle and assign it a strong password using the following statement:

CREATE USER dawiso IDENTIFIED BY password123;

• Make sure to replace password123 with a strong password. For more details, refer to the official Oracle documentation.
• If you choose your own username, make sure to replace it in all following statements.

Allow the user to connect to the database

To allow the user to log in to the database, grant the CREATE SESSION privilege using this statement:

GRANT CREATE SESSION TO dawiso;

Grant permissions to the user

You can grant the required permissions either at the individual asset level or at the schema level to make assets and their metadata visible to the user. To grant access at the asset level, assign the SELECT permission to each table or view you want to ingest into Dawiso:

GRANT SELECT ON schema_name.table_name TO dawiso

• Make sure to replace the schema_name and table_name with the actual schema table and view names.

In Oracle 23c and later, you can grant permissions at the schema level to make all assets within the schema visible:

GRANT SELECT ANY TABLE ON SCHEMA schema_name TO dawiso;

For more details, refer to the official Oracle documentation.

Use system privileged role

As an alternative to granting granular SELECT permissions, you can use a system-privileged role that provides full access to all metadata in Oracle. This approach allows you to control which schemas are ingested later during the data source setup in Dawiso.

For more details, refer to the official Oracle documentation.

First, create the user and grant it the ability to connect:

CREATE USER dawiso IDENTIFIED BY password;
GRANT CREATE SESSION TO dawiso;

• Make sure to replace password123 with a strong password.

Once the privileged role is prepared, grant it the following permissions:

GRANT SELECT ON sys.all_users TO dawiso;
GRANT SELECT ON sys.all_tables TO dawiso;
GRANT SELECT ON sys.all_tab_cols TO dawiso;
GRANT SELECT ON sys.all_constraints TO dawiso;
GRANT SELECT ON sys.all_cons_columns TO dawiso;
GRANT SELECT ON sys.all_indexes TO dawiso;
GRANT SELECT ON sys.all_ind_columns TO dawiso;
GRANT SELECT ON sys.all_views TO dawiso;
GRANT SELECT ON sys.all_procedures TO dawiso;
GRANT SELECT ON sys.all_arguments TO dawiso;