We have several Issues without Security Level set, most of them closed. This enables jira-users to see some they should not have access to...
Is there a way to "reapply" these, I would prefer not the "Edit, set field, save" method.....
An SQL to fix is would be supernice :-)
THis will do it
{code}
mysql> select * from schemeissuesecuritylevels; +-------+------------+-------------+--------+ | ID | NAME | DESCRIPTION | SCHEME | +-------+------------+-------------+--------+ | 10000 | OnlySeeOwn | | 10010 | +-------+------------+-------------+--------+ 1 row in set (0.00 sec) mysql>
update jiraissue set SECURITY=10000 where project=10040 and SECURITY IS NULL; update jiraissue set SECURITY=10000 where project=10130 and SECURITY IS NULL;
{code}
We need to reindex afterwards, otherwise views will stille show the issues to the user
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Maybe find the appropriate level from schemeissuesecuritylevels table and set the id into the security field in jiraissue table! I haven't tried it before, so pls test.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.