cockroachdb / cockroachdb/cockroach
sql: SHOW CREATE USER
Open
C-enhancement
E-starter
P-2
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Debugging and auditing user permissions can be a pain. Roles, privileges, ownership, default privileges, etc. right now might require a daisy-chain of `SHOW GRANTS` and `SHOW DEFAULT PRIVILEGES` commands.
It would be nice to have a single SQL statement (e.g., SHOW CREATE USER ) that outputs a user’s full configuration, including role memberships, system privileges, and default privileges and their source.
Jira issue: CRDB-57540
Epic CRDB-28751
Contributor guide
Assessment
This issue has not been assessed yet.