You can translate the question and the replies:

Permissions when using Centralized Workflow with Private Databases

Hello, What permissions are required for a developer that is making changes on a developer database, to enable them to pull those changes into the canonical database and therefore use those views? The documentation refers to check ins and check outs however that does not reflect terminology in the system. Our developers are following this workflow: 1. Create a view in <dev_db_1> 2. Push the view to the repo so it is checked in to <canonical_db_1> 3. Pull the view from the repo so they can see it in VDP under <canonical_db_1> Some developers are getting errors in the third step saying insufficient access. What permissions are required to do a pull from VCS to a canonical database?
12-10-2022 17:52:48 -0400

1 Answer

Hi, If I get the “Insufficient privileges” error when trying to perform a pull operation from VCS to a canonical database, I would perform the following: * Check whether the developers have “Administrator” privilege over their private databases in the Centralized Workflow. * Verify whether these developers have CONNECT and EXECUTE privileges over the canonical databases to perform a pull operation. * Check whether the developers have WRITE access over the local repository under the “<DENODO_HOME>\work\vdp\repository”. * Then, I would also check the **vdp.log** file under “<DENODO_HOME>\logs\vdp” directory to get more information on this error. If the issue persists and if you are a valid support user, you could create a support case on [Denodo Support Site]( so that our team will assist you. Hope this helps!
Denodo Team
14-10-2022 07:38:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here