Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: support SUPERUSER role option #67087

Open
RichardJCai opened this issue Jun 30, 2021 · 1 comment
Open

sql: support SUPERUSER role option #67087

RichardJCai opened this issue Jun 30, 2021 · 1 comment
Labels
A-sql-privileges SQL privilege handling and permission checks. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Sessions - Deprecated

Comments

@RichardJCai
Copy link
Contributor

RichardJCai commented Jun 30, 2021 •
edited by cockroach-jira-scripts

CockroachDB currently does not support the SUPERUSER option.

superuser status
A database superuser bypasses all permission checks, except the right to log in. This is a dangerous privilege and should not be used carelessly; it is best to do most of your work as a role that is not a superuser. To create a new database superuser, use CREATE ROLE name SUPERUSER. You must do this as a role that is already a superuser.

Currently admin effectively acts as superuser, however superuser is a role option that we should be able to support on any user.

Jira issue: CRDB-8357
@RichardJCai RichardJCai added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-privileges SQL privilege handling and permission checks. labels Jun 30, 2021
@RichardJCai RichardJCai added this to Triage in SQL Sessions - Deprecated via automation Jun 30, 2021
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Jun 30, 2021
@RichardJCai RichardJCai added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Jun 30, 2021
@RichardJCai RichardJCai mentioned this issue Jun 30, 2021
Closed
@rafiss rafiss moved this from Triage to Longer term backlog in SQL Sessions - Deprecated Jul 19, 2021
@rafiss rafiss mentioned this issue Sep 8, 2021
Closed
@rafiss rafiss mentioned this issue Nov 12, 2021
Closed
@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@yuzefovich yuzefovich reopened this May 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-privileges SQL privilege handling and permission checks. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
SQL Sessions - Deprecated
Longer term backlog
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yuzefovich @RichardJCai