Optimize perm_begin and perm_end

[platform/core/security/libprivilege-control.git] / db / load-rules-db.sql

diff --git a/db/load-rules-db.sql b/db/load-rules-db.sql
index 27724ba..35fdb93 100644 (file)
--- a/db/load-rules-db.sql
+++ b/db/load-rules-db.sql
@@ -3,9 +3,18 @@
 
 PRAGMA journal_mode = DELETE;
 
-.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;
+BEGIN TRANSACTION;
+
+-- Delete volatile rules
+DELETE FROM app_permission WHERE is_volatile = 1;
+
+
+.output "/opt/etc/smack/boot-rules.smack"
+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;