UPDATE ......Confluence has now been updated to version 9.2.6. Please see following page for details on updates and maintenance:
Updates
This is not possible, you have to dump and restore everything.
Using the rights commands, this is not difficult. The only thing is that your database will be unavailable during the restore.