Can the DB user be changed once the platform has been created/BDM has been deployed?

Submitted by unai.gaston.caminos on Mon, 12/21/2020 - 15:00
1
+1
-1

Hi,

Consider a platform that was installed with some given:

db.user
bdm.db.user

The platform has been running for some time now, which means that:

  • the platform tables have been created in the engine DB
  • a BDM has been deployed
  • both engine DB and BDM DB tables are full of data

The question is:

Is it possible at this point to change the db.user/bdm.db.user in the database.properties?
(taking the necessary precautions, that is: stopping Bonita platform, and making sure the new users have all the required priviledges and settings)

(I guess that for Oracle DB this may not be straight-forward, as the DB schema is bound to the DB user...)

Any help would be most welcome.

Thanks,

Unai

1 answer

Submitted by danila.mazour_2 on Tue, 12/22/2020 - 10:24
1
+2
-1
This one is the BEST answer!

Yes it is. Just tested it on postgres and it works fine as long as you take the necessary precautions you mention.

Doing it on Oracle might be more complicated though.

Notifications