cockroachdb / cockroachdb/cockroach

Separate EXTERNALCONNECTION and EXTERNALIOIMPLICITAUTH permissions

Open
#172,961 0 comments 0 reactions 0 assignees View on GitHub
C-enhancement
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Right now, a user with EXTERNALCONNECTION but not EXTERNALIOIMPLICITAUTH can create an external connection to a destination that uses implicit auth, but they cannot use implicit auth in a destination specified as a uri (in a changefeed for example).

**Describe the solution you'd like**
We should fully separate these permissions and disallow a user with EXTERNALCONNECTION but not EXTERNALIOIMPLICITAUTH from creating an external connection that would use implicit auth. They would need both permissions to do so.

**Describe alternatives you've considered**
We considered keeping the implication and allowing a user with EXTERNALCONNECTION but not EXTERNALIOIMPLICITAUTH to use implicit auth in a destination specified as a uri without using an external connection.

Jira issue: CRDB-66251

Contributor guide

Open the contributing guide

Research direction

Start by tracing the EXTERNALCONNECTION and EXTERNALIOIMPLICITAUTH permission checks for external connections, implicit-auth destinations, and URI destinations such as changefeeds. Confirm that creating or using any destination with implicit auth requires both permissions, and verify that the existing permission implication is removed.

Written by the indexing model from the issue text.

Assessment

Tech stack
go
Domain
authorization, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.