BEGIN TRANSACTION;
-INSERT INTO all_smack_binary_rules
-SELECT subject, object, access, is_volatile
-FROM all_smack_binary_rules_view
-WHERE NOT EXISTS (SELECT * FROM all_smack_binary_rules);
-- Delete volatile rules
-DELETE FROM app_permission WHERE is_volatile=1;
+DELETE FROM app_permission WHERE is_volatile = 1;
.output "/opt/etc/smack/boot-rules.smack"
-SELECT subject, object, access_to_str(access)
-FROM all_smack_binary_rules
-WHERE all_smack_binary_rules.is_volatile = 0;
-COMMIT TRANSACTION;
\ No newline at end of file
+SELECT subject, object, access_to_str(bitwise_or(access)), "-"
+FROM all_smack_binary_rules
+WHERE is_volatile = 0
+GROUP BY subject, object
+ORDER BY subject, object ASC;
+
+COMMIT TRANSACTION;