Skip to main content

Set up Oracle

Who can do this?

You need your Oracle database administrator or a similar role to run these commands - you may not have access yourself.

Atlan supports the basic authentication method for fetching metadata from Oracle. This method uses a username and password to fetch metadata.

Create user in Oracle​

To create a username and password for basic authentication for Oracle, run the following commands:

CREATE USER <username> IDENTIFIED BY <password>;
GRANT CREATE SESSION TO <username>;
  • Replace <username> with the username you want to create.
  • Replace <password> with the password to use for that username.

Grant permissions​

Atlan requires specific privileges to crawl assets and fetch technical metadata from Oracle.

Grant permissions for metadata extraction​

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.

If these permissions aren’t sufficient in your environment, use the optional approach below. Before proceeding, revoke the previously granted DBA permissions.

(Optional) Grant permissions to query and preview data​

Grant permissions on specific tables​

To grant permissions to query and preview data for specific tables, run the following command for each table you want to provide access to.

GRANT SELECT ON <schema_name>.<table_name> TO <username>;
  • Replace <schema_name> with the name of the schema you want to crawl.
  • Replace <table_name> with the name of the table (or view) you want to crawl.
  • Replace <username> with the username you created.

Grant permissions on any table​

To grant permissions on specific tables, run the following command for each table you want to provide access to.

GRANT SELECT ANY TABLE TO <username>;
  • Replace <username> with the username you created.

This permission allows the new user to query tables or views in any schema except SYS and AUDSYS.

danger

Oracle recommends granting ANY privileges only to trusted users.

These permissions allow you to crawl metadata, preview data, and run queries in Atlan, depending on the privileges granted.