Splunk® DB Connect

Deploy and Use Splunk DB Connect

Acrobat logo Download manual as PDF

This documentation does not apply to the most recent version of Splunk® DB Connect. For documentation on the most recent version, go to the latest release.
Acrobat logo Download topic as PDF

Create and manage identities

An identity object contains database credentials. It comprises the username and password that Splunk DB Connect uses to access your database.

Note that your database credentials are not the same as your Splunk Enterprise credentials. When you configure a DB Connect identity, you use the Splunk Enterprise role-based access control system to define access to the identity.

Dbx-connection ident.png

Create an identity

  1. From within Splunk DB Connect, access the Configuration > Databases > Identities tab and click New Identity.
  2. Complete the following fields:
    • Identity Name
    • Username: Enter the name of the database user you want to connect as.

      Note: Ensure that the database user has sufficient access to the data you want to search. For example, you might create a database user account whose access is limited to the data you want Splunk Enterprise to consume.

    • Password: Enter the password for the user you entered in the Username field.

      Note: Your password should only contain US-ASCII characters. DB Connect requires this field to connect to your database. Your password is encrypted.

    • Use Windows Authentication Domain: This setting is for identities that connect to Microsoft SQL Server databases. Enable this setting if you need to specify a Windows Authentication Domain.
    • Windows Authentication Domain: If you selected the Use Windows Authentication Domain checkbox, enter the domain in this field. For more information about connecting to Microsoft SQL Server databases using Windows Authentication, see "Microsoft SQL Server."
  3. In the Permissions tab, update the Splunk Enterprise permissions for this identity. For more information, see Permissions.
  4. Click Save.

New Cyberark Identity

You can create a new identity in DB Connect that uses your existing Cyberark account information.
From within Splunk DB Connect, access the Configuration > Databases > Identities tab and click New Cyberark Identity. Complete the following fields:

  • URL: For example https://cyberark:8090
  • Certificate: This is the public certificate text.
  • AppID: Enter the ID you created for DB Connect. This is used by Cyberark to identify who accessed your information.
  • Safe: Where you store your Cyberark password.
  • Object: The name of the password object.

Edit Identities

To see a list of the defined identities, go to Configuration > Databases > Identities. To see a list of identities, reference the table below.

To edit an identity, click its name. You can edit the following attributes of an identity, except where noted:

  • Status: Disable an identity by clicking Disable. You cannot disable an identity if any connections are using it. In that case, DB Connect displays an error message that reads Can not disable this identity!.
  • Identity Name: Not editable. To change the name of an identity, clone it, give the clone the name you want, and then delete the original identity.
  • Username, Password, Use Windows Authentication Domain? checkbox and Windows Authentication Domain are the same as Create an identity.
  • Permission: The Permissions table is where you specify the Splunk Enterprise roles that have read, write, or no permissions to the identity. By default, the Splunk Enterprise admin and db_connect_admin roles have read-write access to a new identity, the db_connect_user role has read access, and all other roles have no access.
    • Read access means that Splunk Enterprise roles are able to use the identity.
    • Write access means that Splunk Enterprise roles are able to use and modify the identity.

Reset password for Cyberark Identity

Follow these steps to easily refresh your password for Cyberark directly from DB Connect.

  1. Access the Configuration > Databases > Identities tab and click on the Edit Action.
  2. Click on the Refresh Password button..
Last modified on 22 March, 2022
Configure Splunk DB Connect security and access controls
Create and manage database connections

This documentation applies to the following versions of Splunk® DB Connect: 3.8.0, 3.9.0, 3.10.0

Was this documentation topic helpful?

You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters