Skip to content

Add more stringent DDL and DML permission checks to the system table. #19295

@buzzers

Description

@buzzers

Feature Request

Is your feature request related to a problem? Please describe:
Executing a DDL statement in the system database causes the DDL execution queue to hang, and all subsequent DDL statements are permanently waiting.

Describe the feature you'd like:
When executing DDL and DML statements in the system database, you should check permissions and reject any "write" statements, such as CREATE TABLE.

Teachability, Documentation, Adoption, Migration Strategy:
Some permission checks have been added to DDL and DML statements in #15095, but CREATE and DROP have been ignored. According to the comments, it is for compatibility considerations.
In practice, however, executing CREATE and DROP statements in the system database results in the DDL queue locking, so there is no need to check for compatibility.

Metadata

Metadata

Assignees

Labels

feature/acceptedThis feature request is accepted by product managerspriority/P1The issue has P1 priority.type/feature-requestCategorizes issue or PR as related to a new feature.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions