Hi,
I am planning to take a backup of the some keyspaces from the cluster and trying to restore them to another cluster. The keypsaces that i am trying to take backup has many permissions and roles to them as well as to the tables underneath them.
If we take the backup of the keyspaces using SNAPSHOT tool ,are we taking the users and their roles that belong to those keyspaces too?
If so, after i restore the same backup using sstableloader we are restoring the user_roles and permissions too?
Thanks