How to set up Oracle

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 the SELECT privilege to crawl assets and fetch technical metadata from Oracle.

To grant permissions to the new user, you can either:

• To grant permissions on specific tables, run the following commands:

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

  • Replace <schema_name> with the name of the schema you would like to crawl.
  • Replace <table_name> with the name of the table (or view) you would like to crawl.
    🚨 Careful! You (or your administrator) will need to run these statements for each schema and table or view you want to crawl.
• To grant permissions on any table, run the following commands:

  GRANT SELECT ANY TABLE TO <username>;

  • This permission allows the new user to query tables or views in any schema except SYS and AUDSYS.
  • Oracle recommends that you only grant ANY privileges to trusted users.

These permissions will allow you to crawl metadata and preview and query data in Atlan.