Skip to Content

Remove second password query at DS repository login

Reason

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.

Solution

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.

CMC DS.JPG

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.

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi,

    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

    Raghu