🤓 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.
