Set up Oracle

Configure an Oracle user with the required permissions to enable Atlan to extract metadata from your Oracle database. You need Oracle database administrator access to run these commands.

Prerequisites

Before you begin, make sure you have:

• Oracle database administrator access or equivalent privileges
• Access to run SQL commands in your Oracle database

Create user

Create a dedicated user for Atlan to connect to your Oracle database.

1. Create a new user with basic authentication:

CREATE USER <username> IDENTIFIED BY <password>;
GRANT CREATE SESSION TO <username>;

2. Replace <username> with the username you want to create.
3. Replace <password> with a secure password for that username.

Grant permissions

Grant the necessary permissions to enable Atlan to extract metadata from Oracle.

Least Permission (Recommended)

Grant metadata extraction permissions

1. Run the following commands to grant permissions for metadata extraction:

GRANT SELECT_CATALOG_ROLE TO <username>;
GRANT SELECT ON DBA_TABLES TO <username>;
GRANT SELECT ON DBA_VIEWS TO <username>;
GRANT SELECT ON DBA_TAB_COLUMNS TO <username>;
GRANT SELECT ON DBA_SYNONYMS TO <username>;

Replace <username> with the username you created.

Legacy Permission (Deprecated)

Deprecated

This approach is deprecated. Switch to the Least Permission (Recommended) approach described in the other tab.

Run the following commands to grant permissions for metadata extraction:

GRANT SELECT ANY TABLE TO <username>;
GRANT SELECT ANY SEQUENCE TO <username>;

Replace <username> with the username you created.

Grant query and preview permissions

Grant additional permissions to enable users to query and preview data in Atlan.

Specific tables

Grant access to specific tables or views.

1. Run the following command for each table you want to provide access to:

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

2. Replace <schema_name> with the name of the schema.
3. Replace <table_name> with the name of the table or view.
4. Replace <username> with the username you created.

All tables

Grant access to all tables across schemas.

1. Run the following command to grant access to all tables:

GRANT SELECT ANY TABLE TO <username>;

2. Replace <username> with the username you created.

This permission grants access to query tables or views in any schema except SYS and AUDSYS. Oracle recommends granting ANY privileges only to trusted users.

Next steps

• Crawl Oracle: Create a crawler workflow to extract metadata from Oracle