oceanbase / oceanbase/oceanbase

[Feature]: 请增加mysql.tables_priv和proxies_priv表的支持 || [Feature]: Please add support for mysql.tables_priv and proxies_priv tables

Open
#2,099 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

type: feature
Dominant language
C++
Stars
10.3k
Forks
1.9k
PR merge metrics
No merged PRs in 30d

Description

MySQL的mysql库有4张 *_priv表,OB目前只支持了其中两张。这导致了部分软件,特别是中间件软件在读取用户权限时失败,进而无法支持OB。比如maxscale

  • columns_priv
  • procs_priv
  • proxies_priv
  • tables_priv

请考虑增加mysql.tables_priv和proxies_priv表的支持。


MySQL's mysql library has four *_priv tables, and OB currently only supports two of them. This causes some software, especially middleware software, to fail when reading user permissions, and thus cannot support OB. For example maxscale

  • columns_priv
    -[x]procs_priv
  • proxies_priv
  • tables_priv

Please consider adding support for mysql.tables_priv and proxies_priv tables.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by tracing the existing support for mysql.columns_priv and mysql.procs_priv, then locate the privilege-table compatibility paths used when middleware reads user permissions. Done means mysql.tables_priv and mysql.proxies_priv are supported alongside the two existing *_priv tables so software such as MaxScale can read permissions successfully.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.