Post Security Level on Issues

[B. Normann P. Nielsen]

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 :-)

[B. Normann P. Nielsen · Accepted solution]

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}

[B. Normann P. Nielsen]

We need to reindex afterwards, otherwise views will stille show the issues to the user

[Jobin Kuruvilla [Adaptavist]]

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.