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 b5de8b2..35fdb93 100644 (file)
--- a/db/load-rules-db.sql
+++ b/db/load-rules-db.sql
@@ -11,7 +11,10 @@ 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;