Skip to main content
L
lala_guliyeva1-Visitor
1-Visitor
November 28, 2019
Question

Shared database configuration

  • November 28, 2019
  • 1 reply
  • 913 views

Hello!

I have several database  things with the same configurations, that is, the same database users and passwords for them. When the user password is changed in the database (this happens every few months for security reasons), I have to go into every thing and change the passwords there manually.

 

Is there a way to make some kind of shared configuration for a few things? I tried to use the configuration tables, the documentation says that changing the configuration table data is not inherited.

 

Thanks in advance!

1 reply

Z
zyuan15-Regular Member
5-Regular Member
November 29, 2019

If your user and passwords are for external databases, and they are filled in configuration - JDBC settings field, then we don't have fast solutions.

 

The datashape used in configuration table is system entity, we cannot set default value inside, so no workarounds

L
lala_guliyeva1-VisitorAuthor
1-Visitor
November 29, 2019

we found something like a solution: we can create a new thing and a service for it, which will take the user name and new password as an arguments, find all the databases that have this user in the configuration, and change the password using `SetConfigurationTable`. This has not been implemented yet, because, it seems to me, it is impossible to change the connection configuration table using the database API.

Terms & ConditionsAccessibility statement