Optimize perm_begin and perm_end
[platform/core/security/libprivilege-control.git] / db / load-rules-db.sql
1 .load librules-db-sql-udf.so
2 .separator " "
3
4 PRAGMA journal_mode = DELETE;
5
6
7 BEGIN TRANSACTION;
8
9 -- Delete volatile rules
10 DELETE FROM app_permission WHERE is_volatile = 1;
11
12
13 .output "/opt/etc/smack/boot-rules.smack"
14 SELECT   subject, object, access_to_str(bitwise_or(access)), "-"
15 FROM     all_smack_binary_rules
16 WHERE    is_volatile = 0
17 GROUP BY subject, object
18 ORDER BY subject, object ASC;
19
20 COMMIT TRANSACTION;