cockroachdb / cockroachdb/cockroach
sql: add a statement that can be used by non-admins to drop table statistics
Open
A-sql-table-stats
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Describe the problem**
Only admins can drop statistics on a table. However, Customer requests that AppDBAs who aren't admins should have the ability to do this.
**To Reproduce**
GRANT DELETE ON TABLE system.table_statistics TO appdba;
ERROR: cannot GRANT on system object SQLSTATE: 42501
**Environment:**
- CockroachDB version 22.2.7
Jira issue: CRDB-27955
Contributor guide
Assessment
This issue has not been assessed yet.