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.

To configure basic authentication for Oracle run the following commands:

sql CREATE USER {{username}} IDENTIFIED BY {{password}}; GRANT CREATE SESSION TO {{username}}; 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, preview and query data from within Atlan.

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

Related articles

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