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