sql: add is_grantable to SHOW DEFAULT PRIVILEGES

[cockroach-teamcity]

Exalate commented:

Related PR: https://github.com/cockroachdb/cockroach/pull/85027 Commit: https://github.com/cockroachdb/cockroach/commit/91e1f129bc8aebc113d60db711ee6a29042492fa

---

Release note (sql change): The SHOW DEFAULT PRIVILEGES command now has a column that says if the default privilege will give the grant option to the grantee.

Jira Issue: DOC-5189

[dikshant]

@rmloveland another one that could use a bump on the backlog

root@localhost:26257/defaultdb>  SHOW DEFAULT PRIVILEGES
                             -> ;
  role | for_all_roles | object_type | grantee | privilege_type | is_grantable
-------+---------------+-------------+---------+----------------+---------------
  root |       f       | functions   | root    | ALL            |      t
  root |       f       | schemas     | root    | ALL            |      t
  root |       f       | sequences   | root    | ALL            |      t
  root |       f       | tables      | root    | ALL            |      t
  root |       f       | types       | public  | USAGE          |      f
  root |       f       | types       | root    | ALL            |      t
(6 rows)

We have this is_grantable column now when doing SHOW DEFAULT PRIVILEGES Our examples here: https://www.cockroachlabs.com/docs/dev/show-default-privileges.html Could use an update.

[rmloveland]

@dikshant thanks, assigned myself and bumped the prio