Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Working with Oracle DB

Jim Booth May 23, 2015

User Switcher does not work with Oracle XE R2.  I have raised the issue twice on the vendors issue track but like many others who have raised an issue nobody seems to review and answer.

Anybody having similar problems

Jim

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Jim Booth May 28, 2015

After further investigation I found the following as to why it worked with MySQL but not with Oracle XE:

Found that in the Jira table AO-85377D_SWITCH_USER_CONFIG both fields ("Group allowed to switch users" and "Assignable group" were blank when using MySQL but contained (null) when using Oracle.

When in Oracle  I set "Group allowed to switch users" to Jira-administrators and "Assignable group" to Jira-users the plugin worked as advertised.

Also if I changed "Assignable group" to a specific group the plugin no longer worked, as it set "Group allowed to switch users" back to (null).  Therefore if you want to change one field you have to complete both fields.

Jim

TAGS
AUG Leaders

Atlassian Community Events