WS : Use /api/user_properties API by the admin to modify another user's properties

[Laurent Tourreau]

Hi guys

Is it possible to use /api/user_properties by the admin to modify another user's properties?

Laurent TOURREAU

[Teryk Bellahsene]

Hi Laurent,

It's not possible to modify another user's properties. Could you explain why you'd need to do that?

Thanks,

Teryk

[Laurent Tourreau]

Hi Teryk

As SonarQube admin, we want to force "My News issue" notification properties on all users.

We want all our issues warned when they introduce issues.

Regards

Laurent TOURREAU

[mjdet...@gmail.com]

+1 for this ability.  Same use case.  I was actually about to write a script for this but looks like you saved me some time!

Regards,

Matthew DeTullio

[mjdet...@gmail.com]

As a workaround, you can run this SQL directly against the database (this is for MySQL).  It will enable the global My New Issues property for any user who does not already have it enabled.

Use at your own risk!

INSERT INTO properties (prop_key, resource_id, text_value, user_id) SELECT DISTINCT 'notification.SQ-MyNewIssues.EmailNotificationChannel', NULL, 'true', id FROM users WHERE id NOT IN (SELECT DISTINCT user_id FROM properties WHERE prop_key = 'notification.SQ-MyNewIssues.EmailNotificationChannel');

[Laurent Tourreau]

Hi Matthew

It is what we are doing now.

Thanks for your SQL code.

Regards

Laurent

[Teryk Bellahsene]

Hi!

Don't hesitate to vote for https://jira.sonarsource.com/browse/SONAR-4765 and https://jira.sonarsource.com/browse/SONAR-5448

Teryk

[Laurent Tourreau]

Voted!
Thanks for your reply.
Laurent