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

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}