Creating a Project

After adding databases to the DbRunner application, you can create projects for the relevant databases and schemas. It's important to remember that each project corresponds to a schema. After creating a new project, you can assign different permissions to each user under this project and manage your environments.

From the Create Project page, click Create Project, select the relevant database, and continue.

After creating the project, you can edit the project's settings on the page that opens. The tabs on this page are as follows:

Project Detail

This page contains the alias and description for the project.

Connection Detail

Queries run under this project will be run with the user specified here.

If a public user is already defined, you can use one of these users for the connection. To use one of these users, the "public user" option must be enabled when the admin user creates a user for the relevant database on the password vault page.

Schema Options

Corresponds to the current schema in the database. Queries executed will be run under this default schema.

NLS Parameters:

You can change database parameters such as language and date here.

ITSM Options

If DbRunner is integrated with your demand management system, you can make relevant adjustments here.

Roles

This page contains the roles that can be defined under the project. You can create a new role or edit existing ones.

User Roles

You can assign the roles defined on the Roles page to users here. It is possible to assign different roles to each user under each project.

Fields

If you want to obtain detailed information from the user about the deployment, you can add the relevant fields here. For example, you can create a new field to obtain information about the basis for queries and make it mandatory. The user will not be able to start the deployment process without filling in this field.

Datamask / Sensitive Object

If you want to mask user-generated select queries and hide private information, you can make the necessary settings on this tab.

Pre-Script

Queries defined in this tab will be run before user-generated queries are run. For example, if you want to call a procedure or function before starting a deployment, you can define them on this page.

User Defined Scripts

If you have routine report queries that you regularly receive, you can define them under this tab. The user can select and run one of these reports after creating a deploy.

Remove Project

You can use this tab to remove a project. This doesn't delete the project entirely; it simply removes it from the relevant lists.