In general, the Roles Management are stored as part of the Metadata of the Embedded VDP. Hence, when you enabled the External metadata database of Solution Manager it does not include configurations of the Embedded Virtual DataPort. By default, Embedded Virtual DataPort metadata are store under the <SOLUTION_MANGER>\metadata\db.
In case, if you want to take backup of local users and roles from Embedded Virtual DataPort, then you could perform the below steps,
* Use the Design Studio or Administration tool to connect to the embedded Virtual DataPort Server of Solution Manager, typically, the URL would like below as admin
* Navigate to File> Export. In the Exported VQL, you can view user and role details.
Alternatively, you could also use the export script located at <SOLUTION_MANAGER_HOME>\bin as similar as below,
>export.bat/sh --login <login> --password <password> --server //<SOLUTION_MANAGER_HOST>:19999/admin --file <file_name>
For more information, you could refer to the [Export Script](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/export_script) section of the Virtual DataPort Administration Guide.
Hope this helps!