How to configure a credential in senhasegura to use the Database Proxy with Oracle

In this document, you will find a step-by-step guide on how to configure a credential to be used via the Oracle Database Proxy.

It'll take seven steps to configure the Oracle database so that it’s accessible via Database proxy in senhasegura, this document is the sixth step.

Requirements

• Oracle DB Server configured the minimum version is 19.0.0.0.0
• Server with ORAPKI installed to create Wallets.
• Connectivity of the user's workstation with senhasegura on ports 1521 and 2484.
• Certificate authority (CA) for signing Oracle DB certificates and the database credential.
• Database client installed.
  • Dbeaver, minimum version: 23.1.0
  • SQLPlus, minimum version: 21.0.0.0.0
  • SQL Developer, minimum version: 23.1.0.097
• Don’t have filters enabled for the certificate.

Create a credential

There are two ways to access the Credentials configuration area.
The first way is through the menu Quick actions, located in the top toolbar. To configure a credential using quick actions, follow the steps below:

1. Click on the icon Quick actions, represented by a sheet of paper with the sum sign, and select Credential.

The second way is by accessing the Grid Menu. To do this, follow the steps below:

1. In the upper left corner of senhasegura, click Grid Menu, represented by the nine squares, and select PAM Core.
2. In the side menu, select Credentials > All.
3. Click on the icon View Actions, represented by the three vertical dots, and click +New.

Both actions will open a new pop-up window with the credential registration form. Fill in the following information to configure the new credential:

In the Information tab, fill in:

1. Username: choose username.
2. Password type: choose Local Admin or Local User.
3. Device: choose the Database type of device.
4. Status: select the Enable option.
5. Password: It’s not necessary to create a password, as authentication will be through the certificate.

In the Session Configuration tab, go to the Certificate section and fill in:

1. In the option Certificate file, click Choose file and select the <CREDENTIAL>.crt file previously created for the credential.
2. In the option Key file, click Choose file and select the <CREDENTIAL>.key file previously created for the credential.
3. If your key has a password, enter it in the Key password field.
   Attention

   If the user used a password to create the certificate, in this field you will need to enter the same password created by the user.

4. Click Save.

The system will display a confirmation message, certifying that the credential is registered.

Finishing the sixth step of configuring Oracle to be used via Database Proxy, access the document How to configure IDEs for the end user to connect to Oracle DB to perform the seventh part of the configuration.

Do you still have questions? Reach out to the senhasegura Community.