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.
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 CMC
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.
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.
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.
After confirm all windows with OK, the password query is removed.
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
Hi Raghu,
thank for your reply. That is good to know. I will keep that in mind for future projects.
Thanks
Severin