pingcap / pingcap/tidb

Add an empty `procs_priv` table for compatibility

Open
#49,665 6 comments 1 reaction 1 assignee Claimed by @dveeden View on GitHub
type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

**Is your feature request related to a problem? Please describe:**

On the **Privileges** page of phpmyadmin, it will query the `tables_priv` table and the `procs_priv` at the same time.

But unfortunately, TiDB doesn't support stored procedure and stored function (related issue: https://github.com/pingcap/tidb/issues/17524), so it doesn't has the`procs_priv` table.

The user of phpmyadmin cannot access the **Privileges** page due to the `Table 'mysql.procs_priv' doesn't exist` error:

![image](https://github.com/pingcap/tidb/assets/5086433/46064120-f41a-4bfe-b0df-2be515e95ff7)

**Describe the feature you'd like:**

Add a `procs_priv` table like mysql:

https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html#grant-tables-procs-priv

Since TiDB do not support stored procedures, this can be an empty table.

**Describe alternatives you've considered:**

Fixed on the phpmyadmin side. But I am not sure if there are another database management tool has same problem.

**Teachability, Documentation, Adoption, Migration Strategy:**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.