How to set up Oracle

Have more questions? Submit a request
πŸ€“ Who can do this? You will probably need your Oracle database administrator 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>;

-- Grant SELECT permissions on all the objects you want to provide access to
GRANT SELECT ON <schema_name>.<table_name> TO <username>;
  • Replace <username> with the username you want to create.
  • Replace <password> with the password to use for that 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.

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

🚨 Careful! You (or your administrator) will need to run these statements for each schema and table or view you want to crawl.

Related articles

Was this article helpful?
0 out of 0 found this helpful