Skip to content

Check grants for databases in case of renaming databases#40906

Merged
nikitamikhaylov merged 5 commits intomasterfrom
rbac-rename-query
Sep 5, 2022
Merged

Check grants for databases in case of renaming databases#40906
nikitamikhaylov merged 5 commits intomasterfrom
rbac-rename-query

Conversation

@nikitamikhaylov
Copy link
Copy Markdown
Member

Changelog category (leave one):

  • Bug Fix (user-visible misbehavior in official stable or prestable release)

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Fixed a behaviour when user with explicitly revoked grant for dropping databases can still drop it.

Information about CI checks: https://clickhouse.com/docs/en/development/continuous-integration/

@robot-ch-test-poll1 robot-ch-test-poll1 added the pr-bugfix Pull request with bugfix, not backported by default label Sep 1, 2022
@tavplubix tavplubix self-assigned this Sep 1, 2022
Copy link
Copy Markdown
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This may be unneeded, because I copy-pasted the test

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

no-parallel tag can be avoided by using unique database and user name, it's quite easy to do in .sh test:

${CLICKHOUSE_CLIENT} --multiline --multiquery -q """
DROP DATABASE IF EXISTS database_02416_${CLICKHOUSE_DATABASE};
CREATE DATABASE database_02416__${CLICKHOUSE_DATABASE};
DROP USER IF EXISTS user_test_02416__${CLICKHOUSE_DATABASE};
CREATE USER user_test_02416__${CLICKHOUSE_DATABASE} IDENTIFIED WITH plaintext_password BY 'user_test_02416';

Comment on lines 185 to 189
Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

We don't have EXCHANGE DATABASES query

@nikitamikhaylov nikitamikhaylov merged commit 33e5303 into master Sep 5, 2022
@nikitamikhaylov nikitamikhaylov deleted the rbac-rename-query branch September 5, 2022 10:38
fanqi1909 pushed a commit to ByConity/ByConity that referenced this pull request May 8, 2024
liyinsg added a commit to liyinsg/ByConity that referenced this pull request Jun 19, 2024
dogauzuncukoglu pushed a commit to edgedelta/ByConity that referenced this pull request Jul 28, 2024
dogauzuncukoglu pushed a commit to edgedelta/ByConity that referenced this pull request Jul 28, 2024
dogauzuncukoglu pushed a commit to edgedelta/ByConity that referenced this pull request Jul 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-bugfix Pull request with bugfix, not backported by default

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants