Additional guidance for restoring users and grants from self-hosted database to CockroachDB Cloud

[sheaffej]

John Sheaffer (sheaffej) commented:

The section in the docs that describes how to restore a self-hosted database to CockroachDB Cloud could use expanding to include how to restore users that were created in the self-hosted cluster, as well as grants on the database that those users had.

This is the section and page where restoring a self-hosted database into CockroachDB Cloud is described:
https://www.cockroachlabs.com/docs/cockroachcloud/backups-page.html#back-up-a-self-hosted-cockroachdb-cluster-and-restore-into-a-cockroachdb-cloud-cluster

And we should consider adding pointers to:

Restoring users from system.users. backup
https://www.cockroachlabs.com/docs/v21.2/restore#restoring-users-from-system-users-backup

and Show a backup with privileges
https://www.cockroachlabs.com/docs/v21.2/show-backup.html#show-a-backup-with-privileges
...even better to include an example query that would extract the GRANT statements for the users and databases being restored into CockroachDB Cloud

Jira Issue: DOC-2825

[exalate-issue-sync]

Lauren Hirata Singh (lnhsingh) commented:
Ian Evans - not sure if this should be Cloud or under I/O, so cc-ing Kathryn Hancox on this.