Changing Security Role Password in Oracle GoldenGate 12.3 Microservices

One of the nice things about Oracle GoldenGate 12.3 Microserivces, is the flexibility we now have to interact with Oracle GoldenGate. Additionally, what comes with Oracle GoldenGate 12.3 Microservices is a new role based security frame work.

When you first setup Oracle GoldenGate 12.3 Microservices, you setup your ServiceManager and initial deployment. Upon setting this up, you will assign a new administrator to the frame work. This is a different user than the Oracle GoldenGate user within the database. This user is the user assigned to the security role (highest role). This user is the equivalent of the SYS user in the Oracle Database and has access to everything within the security framework of Oracle GoldenGate 12.3 Microservices. It should be a no-brainer to keep the password for this user secure and to as few people as possible.

Now, when you look at the user from inside of the Administration Server (AdminServer); notice there is not an update button under the Action category (Figure 1).

Figure 1:

So how do we update this password for a user in the security role, much less any other role? Remember, when I said Oracle GoldenGate 12.3 Microservices was “flexible”? We have to use the RESTful API to update the password.

The exact end-point that you have to use is: /services/v2/authorizations/{role}/{user}. More info can be found here.

The way that I update the password is by using a JSON document and a simple cURL command. Below is a simple JSON document example:

{
“credential”:”welcome1″
}

Then the cURL command I use is:

curl -u oggadmin:********* -H “Content-Type:application/json” -H “Accept:application/json” -X PATCH http://localhost:16001/services/v2/authorizations/security/oggadmin -d @update_security_password.json| python -mjson.tool

After running the cURL command, the password for the oggadmin user is updated. You should see some similiar output to this output.

{
“$schema”: “api:standardResponse”,
“links”: [
{
“href”: “http://localhost:16001/services/v2/authorizations/security/oggadmin”,
“mediaType”: “application/json”,
“rel”: “canonical”
},
{
“href”: “http://localhost:16001/services/v2/authorizations/security/oggadmin”,
“mediaType”: “application/json”,
“rel”: “self”
}
],
“messages”: [],
“response”: {
“links”: [
{
“href”: “http://localhost:16001/services/v2/authorizations/security/oggadmin”,
“mediaType”: “application/json”,
“rel”: “self”
}
]
}
}

Hope this helps you understand how to change a user password from REST within the Oracle GoldenGate 12.3 Microservices Architecture.

Enjoy!!!

Please follow and like:

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.