Skip to Content
Author's profile photo Severin Thelen

Remove second password query at DS repository login


In some cases you get a second password query if you want to log on the repository. The second  password query looks like the following screenshot.

Repo Password.png

Reason for this second login are missing permissions on the enterprise server. To remove the second login you have to change the permissions at the CMC.


First you have to log on the CMC with an admin user. If you are logged in, you open the Data Services section of the CMCCMC Home.JPG

In the Data Services sections you have two options to change the permissions, depending on your requirements.

If you want to remove for every repository, you open the User Security of the repository folder on the left side. Otherwise you open the User Security of the specific repository.


On the new user security window you see the different user groups. Select the user group (in my case it is the Administrators group) and click Assign Security.

User Security.JPG

The problem is, that the Full Control access level does not have all permission. There for you have open the Advanced tab. In the advanced tab, you click the hyperlink Add/Remove Rights.

Advanced Tab.png

In the new window you open the topic Application on the left side and the subtopic Data Services Repository. Now you can the see the specific Data Services rights for Repositorys. To remove the second password query grand the first two right and apply these to object and subobject.

Add Remove Rights.png

After confirm all windows with OK, the password query is removed.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Raghunathan Balasubramanian
      Raghunathan Balasubramanian


      If you are using MS SQL DB based authentication this is a common case. There is an argument that such an option to use the user password in case of database authentication can cause data privacy issue. I've had this issue raised when I was with a pharmaceutical client.

      In such cases it is better to use AD Groups which will have an integrated authentication for both BODS and databases.

      kind regards


      Author's profile photo Severin Thelen
      Severin Thelen
      Blog Post Author

      Hi Raghu,

      thank for your reply. That is good to know. I will keep that in mind for future projects.