You can translate the question and the replies:

How to store the data of role management to external metadataDB (Solution Manager)

Hi denodo team In general, the Roles Management are stored as part of the Metadata of the Embedded DB. After i enabled the External metadata database of Solution Manager, the new value should be store into External metadata database when i add a new role. but it wasn't. i checked all the tables in External metadata database of solution manager side. It seems there is no table about role management like the table vdp_role in vdp server. im not asking how to migrate data from embedded db to external db. I want to confim that why the role still store in Embedded DB even after i enabled the External metadata database of Solution Manager. And how can i avoid this problem? I also ask the same question at these tickct . I will be appriciate if you guys could reply it. [Question about external database](https://community.denodo.com/answers/question/details?questionId=9064u000000L8ajAAC&title=Question+about+external+database) [Role management in solution manager](https://community.denodo.com/answers/question/details?questionId=9064u000000H9pCAAS&title=Role+management+in+solution+manager)
user
15-08-2021 09:09:33 -0400

4 Answers

Hi, I am able to view the new roles added in the external metadata database. You can query the table vdp_role or vdp_users to get details on the new role and user. If you have a valid Support account, I would request you to open a support case where the Support Team can assist you. Best Regards, Support Team
Denodo Team
17-08-2021 15:44:42 -0400
Hi denodo team Thank you for your reply. I just got primary account yesterday and had already created a case. I will ask some details in case side. Thanks
user
17-08-2021 20:16:46 -0400
> I am able to view the new roles added in the external metadata database. You can query the table vdp_role or vdp_users to get details on the new role and user. BTW, i think you didnt get my point. Not the vdp_role or vdp_users in VDP server. I m talking about the solution manager side. This problem only occur in k8s/docker user. Anyway, i will talk this issue with support team. Thankyou
user
18-08-2021 02:20:32 -0400
Hi, Apologies for the unintentional mistake. I would like to inform you that in Solution Manager, when you configure an external database for storing metadata, the role/user information is not stored in that external database, but stored in the embedded Derby, which is the current specification and the expected behavior of the Denodo Platform. Hope this helps!
Denodo Team
13-09-2021 18:19:19 -0400
You must sign in to add an answer. If you do not have an account, you can register here