Adding Databases

You can add Oracle, PostgreSQL, MSSQL, DB2, and MySQL databases to the DbRunner and run your queries. To add a database, select the database from the Databases tab in the left menu and complete the process.

After the addition process is complete, an alias must be assigned to the database and a notification group must be selected. If the notification group field is empty, a new group must be created on the settings page. This group will determine the channel through which notifications should be sent.

After entering the account and connection information, dbrunner services must be installed on the relevant database from the service install tab for Oracle databases. To do this, go to the Install Service tab and complete the required fields before completing the process. You cannot perform DDL deployments or create a baseline without doing this.

If you will only be running DML queries on the database and will not define detailed roles, ensure that the relevant user has the RESOURCE, CREATE SESSION, SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, and DELETE ANY TABLE permissions.

If you will be creating a pipeline and running DDL queries, the user must have the following permissions:

ALTER ANY DIMENSION, ALTER ANY INDEX, ALTER ANY INDEXTYPE, ALTER ANY LIBRARY, ALTER ANY MATERIALIZED VIEW,
ALTER ANY PROCEDURE, ALTER ANY SEQUENCE, ALTER ANY TABLE, ALTER ANY TRIGGER, ALTER ANY TYPE, ALTER ROLLBACK SEGMENT,
ALTER SESSION, COMMENT ANY MINING MODEL, COMMENT ANY TABLE, CREATE ANY DIMENSION, CREATE ANY DIRECTORY,
CREATE ANY EDITION, CREATE ANY INDEX, CREATE ANY INDEXTYPE, CREATE ANY JOB, CREATE ANY LIBRARY,
CREATE ANY MATERIALIZED VIEW, CREATE ANY PROCEDURE, CREATE ANY SEQUENCE, CREATE ANY SYNONYM, CREATE ANY TABLE,
CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE ANY VIEW, CREATE EXTERNAL JOB, CREATE INDEXTYPE, CREATE JOB,
CREATE LIBRARY, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE ROLLBACK SEGMENT,
CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE USER,
CREATE VIEW, DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION, DELETE ANY TABLE, DROP ANY EDITION, DROP ANY INDEX,
DROP ANY INDEXTYPE, DROP ANY LIBRARY, DROP ANY MATERIALIZED VIEW, DROP ANY PROCEDURE, DROP ANY SEQUENCE,
DROP ANY SYNONYM, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY TYPE, DROP ANY VIEW, DROP PUBLIC SYNONYM,
EXECUTE ANY CLASS, EXECUTE ANY INDEXTYPE, EXECUTE ANY LIBRARY, EXECUTE ANY OPERATOR, EXECUTE ANY PROCEDURE,
EXECUTE ANY PROGRAM, EXECUTE ANY RULE, EXECUTE ANY RULE SET, EXECUTE ANY TYPE, GLOBAL QUERY REWRITE,
GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE, GRANT ANY ROLE, INSERT ANY TABLE, LOCK ANY TABLE,
MANAGE SCHEDULER, MERGE ANY VIEW, PURGE DBA_RECYCLEBIN, READ ANY ANALYTIC VIEW CACHE, READ ANY FILE GROUP,
READ ANY TABLE, REDEFINE ANY TABLE, SELECT ANY CUBE, SELECT ANY CUBE BUILD PROCESS, SELECT ANY CUBE DIMENSION,
SELECT ANY DICTIONARY, SELECT ANY MEASURE FOLDER, SELECT ANY MINING MODEL, SELECT ANY SEQUENCE, SELECT ANY TABLE,
SELECT ANY TRANSACTION, TRANSLATE ANY SQL, UNDER ANY TABLE, UNDER ANY TYPE, UNDER ANY VIEW, UNLIMITED TABLESPACE,
UPDATE ANY CUBE, UPDATE ANY TABLE, USE ANY JOB RESOURCE, RESOURCE