cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Shared database configuration

lala_guliyeva
10-Marble

Shared database configuration

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!

2 REPLIES 2

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

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.

Top Tags