Oracle

Add Oracle as a decube connection and help your team discover, document and monitor data assets to drive data-driven insights and decisions.

Connecting to decube is as easy as providing us with read-only credentials to your Oracle database. At a minimum, we require

• Username

• Password

• Host

• Port

• Database

Form for connecting to Oracle

Create User for Decube

A custom user would allow for a granular configuration of the user on your database and your connection to decube.

1. Create the user, and change password accordingly.

CREATE USER 'decube' IDENTIFIED BY '<password>';

1. Grant read-only privileges on all data dictionary views

GRANT SELECT_CATALOG_ROLE TO 'decube';

1. Grant access to the decube user. Here table can be * if you're using decube to observe the whole database. For only a few tables, you'll have to run this command multiple times changing the table value.

GRANT CONNECT TO decube;
GRANT SELECT ON <schema>.<table> TO decube;