Skip to content

docs: document column-level privileges (v8.5)#22574

Open
hfxsd wants to merge 12 commits intopingcap:feature/preview-v8.5.6from
hfxsd:release-8.5-doc-column-privilege-21437
Open

docs: document column-level privileges (v8.5)#22574
hfxsd wants to merge 12 commits intopingcap:feature/preview-v8.5.6from
hfxsd:release-8.5-doc-column-privilege-21437

Conversation

@hfxsd
Copy link
Copy Markdown
Collaborator

@hfxsd hfxsd commented Mar 18, 2026

What is changed, added or deleted? (Required)

  • Add a Chinese user doc for TiDB column-level privileges (column-privilege-management.md).
  • Update TOC.md and privilege-management.md to link the new doc.
  • Update GRANT <privileges> / REVOKE <privileges> docs and mysql-compatibility.md to reflect column-level privilege support in TiDB v8.5.

Which TiDB version(s) do your changes apply to? (Required)

  • master (the latest development version)
  • v9.0 (TiDB 9.0 versions)
  • v8.5 (TiDB 8.5 versions)
  • v8.1 (TiDB 8.1 versions)
  • v7.5 (TiDB 7.5 versions)
  • v7.1 (TiDB 7.1 versions)
  • v6.5 (TiDB 6.5 versions)
  • v6.1 (TiDB 6.1 versions)
  • v5.4 (TiDB 5.4 versions)

What is the related PR or file link(s)?

Do your changes match any of the following descriptions?

  • Delete files
  • Change aliases
  • Need modification after applied to another branch
  • Might cause conflicts after applied to another branch

@hfxsd hfxsd added the translation/from-docs-cn This PR is translated from a PR in pingcap/docs-cn. label Mar 18, 2026
@hfxsd hfxsd self-assigned this Mar 18, 2026
@ti-chi-bot ti-chi-bot bot added contribution This PR is from a community contributor. size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. labels Mar 18, 2026
@gemini-code-assist
Copy link
Copy Markdown
Contributor

Summary of Changes

Hello, I'm Gemini Code Assist1! I'm currently reviewing this pull request and will post my feedback shortly. In the meantime, here's a summary to help you and other reviewers quickly get up to speed!

This pull request aims to update the TiDB v8.5 documentation to incorporate comprehensive information regarding column-level privileges. The changes introduce a new dedicated Chinese user guide for this feature and ensure that existing documentation, including the table of contents, privilege management guides, and MySQL compatibility notes, accurately reflect the new functionality.

Highlights

  • New Documentation Added: A new Chinese user document (column-privilege-management.md) has been added to detail TiDB column-level privileges.
  • Navigation Updates: The TOC.md and privilege-management.md files were updated to include links to the newly added column-level privilege documentation.
  • Privilege Command Reflection: Documentation for GRANT <privileges> and REVOKE <privileges>, along with mysql-compatibility.md, has been updated to reflect the support for column-level privileges in TiDB v8.5.

🧠 New Feature in Public Preview: You can now enable Memory to help Gemini Code Assist learn from your team's feedback. This makes future code reviews more consistent and personalized to your project's style. Click here to enable Memory in your admin console.

Using Gemini Code Assist

The full guide for Gemini Code Assist can be found on our documentation page, here are some quick tips.

Invoking Gemini

You can request assistance from Gemini at any point by creating a comment using either /gemini <command> or @gemini-code-assist <command>. Below is a summary of the supported commands on the current page.

Feature Command Description
Code Review /gemini review Performs a code review for the current pull request in its current state.
Pull Request Summary /gemini summary Provides a summary of the current pull request in its current state.
Comment @gemini-code-assist Responds in comments when explicitly tagged, both in pull request comments and review comments.
Help /gemini help Displays a list of available commands.

Customization

To customize Gemini Code Assist for GitHub experience, repository maintainers can create a configuration file and/or provide a custom code review style guide (such as PEP-8 for Python) by creating and adding files to a .gemini/ folder in the base of the repository. Detailed instructions can be found here.

Limitations & Feedback

Gemini Code Assist may make mistakes. Please leave feedback on any instances where its feedback is incorrect or counter productive. You can react with 👍 and 👎 on @gemini-code-assist comments. If you're interested in giving your feedback about your experience with Gemini Code Assist for GitHub and other Google products, sign up here.

Footnotes

  1. Review the Privacy Notices, Generative AI Prohibited Use Policy, Terms of Service, and learn how to configure Gemini Code Assist in GitHub here. Gemini can make mistakes, so double check it and use code with caution.

Copy link
Copy Markdown
Contributor

@gemini-code-assist gemini-code-assist bot left a comment

Choose a reason for hiding this comment

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

Code Review

This pull request aims to add documentation for column-level privileges in TiDB v8.5. However, the only change submitted for review is the addition of temp.md, a file that appears to be a temporary placeholder. This file does not align with the stated goals of the pull request. My review feedback recommends removing this file to ensure the pull request only contains relevant documentation changes.

I am having trouble creating individual review comments. Click here to see my feedback.

temp.md (1)

medium

This file appears to be a temporary test file that may have been accidentally included in the pull request. Its name and content (This is a test file.) are not related to the PR's goal of documenting column-level privileges. It's recommended to remove this file from the pull request to keep the commit history clean and focused on the intended documentation.

Synced from: pingcap/docs-cn#21437
Target PR: pingcap#22574
AI Provider: gemini

Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
@ti-chi-bot ti-chi-bot bot added size/L Denotes a PR that changes 100-499 lines, ignoring generated files. and removed size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. labels Mar 18, 2026
@hfxsd
Copy link
Copy Markdown
Collaborator Author

hfxsd commented Mar 18, 2026

/retest

@hfxsd
Copy link
Copy Markdown
Collaborator Author

hfxsd commented Mar 18, 2026

/retest

Update docs to reflect implemented privilege visibility in INFORMATION_SCHEMA and mysql system tables.

- Mark COLUMN_PRIVILEGES, SCHEMA_PRIVILEGES, and TABLE_PRIVILEGES as summarizing privilege information visible to the current user (information-schema.md).
- Remove an obsolete link and clarify viewing column-level privileges via INFORMATION_SCHEMA.COLUMN_PRIVILEGES (column-privilege-management.md).
- Note that mysql.columns_priv is supported starting in v8.5.6 (privilege-management.md).

These changes align the documentation with implemented behavior for column-, schema-, and table-level privilege reporting.
@hfxsd hfxsd requested a review from lilin90 March 19, 2026 08:18
@ti-chi-bot
Copy link
Copy Markdown

ti-chi-bot bot commented Mar 19, 2026

@fzzf678: adding LGTM is restricted to approvers and reviewers in OWNERS files.

Details

In response to this:

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes-sigs/prow repository.

@ti-chi-bot
Copy link
Copy Markdown

ti-chi-bot bot commented Mar 19, 2026

@Frank945946: adding LGTM is restricted to approvers and reviewers in OWNERS files.

Details

In response to this:

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes-sigs/prow repository.

@hfxsd hfxsd changed the base branch from release-8.5 to feature/preview-v8.5.6 April 1, 2026 03:03
@hfxsd hfxsd requested a review from qiancai April 8, 2026 07:54
Co-authored-by: Grace Cai <qqzczy@126.com>
@hfxsd hfxsd added lgtm and removed contribution This PR is from a community contributor. labels Apr 10, 2026
@hfxsd
Copy link
Copy Markdown
Collaborator Author

hfxsd commented Apr 10, 2026

/approve

@ti-chi-bot
Copy link
Copy Markdown

ti-chi-bot bot commented Apr 10, 2026

[APPROVALNOTIFIER] This PR is APPROVED

This pull-request has been approved by: hfxsd

The full list of commands accepted by this bot can be found here.

The pull request process is described here

Details Needs approval from an approver in each of these files:

Approvers can indicate their approval by writing /approve in a comment
Approvers can cancel approval by writing /approve cancel in a comment

@ti-chi-bot ti-chi-bot bot added the approved label Apr 10, 2026
@hfxsd
Copy link
Copy Markdown
Collaborator Author

hfxsd commented Apr 10, 2026

/retest

@hfxsd hfxsd added the do-not-merge/hold Indicates that a PR should not merge because someone has issued a /hold command. label Apr 10, 2026
Co-authored-by: Grace Cai <qqzczy@126.com>
@hfxsd hfxsd removed the do-not-merge/hold Indicates that a PR should not merge because someone has issued a /hold command. label Apr 10, 2026
@hfxsd hfxsd added the do-not-merge/hold Indicates that a PR should not merge because someone has issued a /hold command. label Apr 10, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

approved do-not-merge/hold Indicates that a PR should not merge because someone has issued a /hold command. lgtm size/L Denotes a PR that changes 100-499 lines, ignoring generated files. translation/from-docs-cn This PR is translated from a PR in pingcap/docs-cn.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants