Connect Oracle

1. Create a read-only user in Oracle

Bigeye only requires a read-only user for connecting to your database. Here is a sample for creating one, along with the permission to connect:

CREATE USER bigeye_read_only
IDENTIFIED BY <your_password_here>

GRANT CREATE SESSION to bigeye_read_only;

2. Grant select privileges to the schemas that Bigeye should be able to access:

BEGIN
  FOR x IN (SELECT  owner,object_name FROM dba_objects WHERE owner IN (‘SCHEMA_1’, 'SCHEMA_2', ‘SCHEMA_N’) and object_type in ('TABLE','VIEW'))
  LOOP
   EXECUTE IMMEDIATE 'GRANT SELECT ON '||x.owner||'.'|| x.object_name ||' TO BIGEYE_READ_ONLY;
  END LOOP;
END;

Please consider the following:

  • Bigeye uses multiple sessions during connection. Please ensure you have an appropriate number configured. For more information on sessions and how to alter them, read here.

  • You may also enforce limits to database resources by creating a profile for the Bigeye user. Since connections can sit idle, it may be good to enforce a low IDLE_TIME. For more information, read here.

  • If your Oracle instance is deployed in the cloud, you may need to whitelist Bigeye’s static IP 35.163.65.120, depending on your security settings.