cancel
Showing results for 
Search instead for 
Did you mean: 

Changing User's Database Credentials using REST (SBO x4.2 CMC).

former_member502966
Discoverer
0 Kudos

Greetings!

I've been working on an application that receives SOAP calls from an Access Manager external app and translate them into REST calls into the BO CMC endpoint for doing basic user and access managing.

I've been searching for a solution to update the user's Database UserName and Database Credentials through REST calls but found no way of doing it.

When using GET calls to receive user information I will get no mention to it in the listed attributes but I could found the way to read it using a cmc query :

<attrs xlns="http://www.sap.com/rws/bip">

<attr name="query" type="string"> select * from CI_SYSTEMOBJECTS where si_id ='(user_id)' </attr>

</attrs>

Between the returned attributes I got:

<attr name="SI_DATA" type="string">

<attrs>

<attr name="DBUSER" type="string"> TestDBUser </attr>

</attrs>

</attr>

Tried adding this attribute when doing a PUT call for updating but it seems to be ignored

<link href="http://(server_address)/biprws/v1/users/(user_id)" rel="alternate"/>

<entry xmlns="http://www.w3.org/2005/Atom">

<content type="application/xml">

<attrs xmlns="http://www.sap.com/rws/bip">

<attr name="cuid" type="string">Aa5kYv3MwCxDpeZkFRDLhSQ</attr>

<attr name="forcepasswordchange" type="bool">false</attr>

(...)

<attr name="SI_DATA" type="string"> <attrs>

<attr name="DBUSER" type="string">Teste_bduser</attr>

</attrs></attr> </attrs> </content> </entry>

The other attributes will be updated but the DBUSER will not be updated (and won't show up in the response) .

Is there any way of doing this (updating both the DBUSER and the DBPassword) using REST calls?

Or the only way of doing this is using the SDK?

Thank you.

denis_konovalov
Active Contributor

I have fixed your tag, please select more careful next time.

Accepted Solutions (1)

Accepted Solutions (1)

daniel_paulsen
Active Contributor

Hi Ines,

I assume you are trying to update the logon for a Crystal Report. This cannot be done using the REST APIs but it can be achieved using the .NET or Java SDK.

You need to retrieve a Desktop.Report object and get its DatabaseLogons collection.The userID/Password can be changed and then committed back to the CMS database. Optionally you can use CustomDatabaseLogons and change both the Database driver and credentials.

Dan

Answers (1)

Answers (1)

former_member502966
Discoverer
0 Kudos

Thank you for your answer.

I will try to do it using the Java SDK then.

Greetings