Granting BACKUP to all tables causes stack trace if there's a sequence

[smcvey]

Describe the problem

Attempting to grant BACKUP to all tables causes a stack trace if there are sequences.

To Reproduce

New cluster:

CREATE SEQUENCE s;
GRANT BACKUP ON ALL TABLES IN SCHEMA public TO <user>;

Creates this output:

ERROR: internal error: table descriptor is not valid
tabledesc.Mutable: {ID: 104, Version: 1, ModificationTime: "1705494412.925153755,0", ParentID: 100, ParentSchemaID: 101, State: PUBLIC, Sequence: true, NextColumnID: 0, Columns: [{ID: 1, TypeID: 20, Null: false}], NextFamilyID: 0, Families: [{ID: 0, Columns: [1]}], PrimaryIndex: 1, NextIndexID: 0, Indexes: [{ID: 1, Unique: false, KeyColumns: [{ID: 1, Dir: ASC}]}]}
: relation "s" (104): user nobody must not have [BACKUP] privileges on sequence "s"
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/table.go:337: writeTableDescToBatch()
github.com/cockroachdb/cockroach/pkg/sql/table.go:297: writeSchemaChangeToBatch()
github.com/cockroachdb/cockroach/pkg/sql/grant_revoke.go:372: startExec()
github.com/cockroachdb/cockroach/pkg/sql/plan.go:520: func2()
github.com/cockroachdb/cockroach/pkg/sql/walk.go:112: func1()
github.com/cockroachdb/cockroach/pkg/sql/walk.go:299: visitInternal()
github.com/cockroachdb/cockroach/pkg/sql/walk.go:79: visit()
github.com/cockroachdb/cockroach/pkg/sql/walk.go:43: walkPlan()
github.com/cockroachdb/cockroach/pkg/sql/plan.go:523: startExec()
github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:175: Start()
github.com/cockroachdb/cockroach/pkg/sql/colexec/columnarizer.go:183: Init()
github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:94: init()
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92: CatchVectorizedRuntimeError()
github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:103: Init()
github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:245: func2()
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92: CatchVectorizedRuntimeError()
github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:244: init()
github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:278: Run()
github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:320: Run()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:906: Run()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1946: PlanAndRun()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1661: func3()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1664: PlanAndRunAll()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2342: execWithDistSQLEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1882: dispatchToExecutionEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1104: execStmtInOpenState()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:145: func1()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:3317: execWithProfiling()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:144: execStmt()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2228: func1()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2233: execCmd()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2150: run()

HINT: You have encountered an unexpected error.

Expected behavior
When applying with the ALL TABLES, it should just ignore sequences completely (considering that attempting to apply BACKUP directly to a sequence isn't allowed).

Environment:

• CockroachDB version: 23.2.0-rc.2

Jira issue: CRDB-35387