sql: support DROP OWNED BY command #55381
Description
To facilitate dropping roles, we should support Postgres's DROP OWNED BY command. This drops all owned objects as well as any grants on objects not owned by the role.
Relevant Postgres docs:
https://www.postgresql.org/docs/current/sql-drop-owned.html
https://www.postgresql.org/docs/current/role-removal.html
Epic CRDB-13664
Jira issue: CRDB-3673
Metadata
Metadata
Assignees
Labels
SQL privilege handling and permission checks.Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Might be suitable for a starter project for new employees or team members.SQL Foundations Team (formerly SQL Schema + SQL Sessions)The issue number is anchored by telemetry references.