cockroachdb / cockroachdb/cockroach

multitenant: ability to set default tenant capabilities

Open
#113,157 1 comment 0 reactions 0 assignees View on GitHub
A-multitenancy C-enhancement T-db-server
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Currently, tenant capabilities are granted on a per-tenant basis using the `ALTER TENANT ... GRANT CAPABILITY` syntax.

However, we provide no way for the user to grant a capability to all current and future tenants. Tenant settings allow for all-tenant overrides that apply to all tenants (provided they don't have a tenant-specific) override. A similar feature for tenant capabilities would allow the operator to similarly express the "default" set of capabilities they would like to grant tenants.

You can create a "template" tenant with the set of capabilities you would like by default and use the `CREATE TENANT .. LIKE` syntax, but the capabilities are applied to the tenant only at creation time and thus cannot be updated en-masse later.

Jira issue: CRDB-32780

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.