Zum Inhalt springen

Enhance the security of your instance

Zuletzt aktualisiert am

The security enhancements covered in this article include:

  • Setting up Single Sign-On (SSO)
  • Defining Access Control Lists (ACLs)
  • Using Dremio Service Users
  • Remove Basic Authentication users after bootstrapping
  • You have a STACKIT Dremio instance
  • You have an Entra ID or OAuth Identity Provider.

Using the Local only in a production system is discouraged, as that would lead to the authentication method to be Basic Auth. It is thus recommended to connect the Dremio instance to your organization’s identity provider.

If you are creating a Dremio instance from scratch, follow the guide to Create a Dremio Instance with SSO.

For an existing instance you can follow the tutorial at Setting up SSO for a Dremio Instance.

Access Control Lists (ACLs) in Dremio provide a simple and effective way to control network access to your database instances. Only the IP addresses or IP ranges explicitly defined by you are permitted to establish a connection. All other addresses are denied.

Follow the tutorial on Defining ACLs to learn how to set it up.

Avoid using Personal Access Tokens for data pipelines. Instead, secure your automations by configuring Service Users with the principle of least privilege. You can follow the tutorial on Creating Service Users to learn how to do so.

Service users can also be configured to be federated by your preferred IdP (see next section).

You can also find more information at:

  1. Create a Service User.
  2. Generate an OAuthSecret.

To further secure your service user’s authentication, you can associate the service user to an identity in your organization’s IdP, using external credentials.

Dremio external credentials utilize the standard OAuth 2.0 Token Exchange protocol (RFC 8693). This allows your automated workflows to dynamically swap your Identity Provider’s token for a Dremio session token.

Follow the tutorial on Secure Service Users Authentication to learn how to authenticate a Dremio Service User with a JWT from a STACKIT Service Account.

Remove Basic Authentication Users after Bootstrapping

Section titled “Remove Basic Authentication Users after Bootstrapping”

Currently, it isn’t possible to configure via the STACKIT Portal/SDK which SSO / IdP Federated users have ADMIN role granted to them in Dremio. For this reason, the creator for a STACKIT Dremio service instance can create a user through the STACKIT Portal/SDK - this user is granted ADMIN. This can be done as a first step when configuring Dremio.

After bootstrapping your Dremio instance and ensure that, at least one SSO / IdP Federated user is ADMIN, we recommend removing any users created through the STACKIT Portal. These users can be created ad-hoc, at later point, if necessary.

  1. Open your project in the STACKIT Portal
  2. Navigate to Dremio
  3. Select your Dremio instance and go to the Overview page
  4. In the sidebar, select Users.
  5. Click on the three dots on the right side of a user entry.
  6. Click on Delete.