Skip to Content
0
Jan 02, 2019 at 06:18 PM

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

263 Views Last edit Jan 02, 2019 at 06:20 PM 2 rev

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 :

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"/>

http://www.w3.org/2005/Atom">

<content type="application/xml">

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.