db/rules-db-data.sql

   1 -- !!! CAUTION !!!
   2 -- Beware of updating!
   3 -- Remember that you might insert things to a filled database.
   4
   5 .load librules-db-sql-udf.so
   6 PRAGMA foreign_keys = ON;
   7
   8 BEGIN TRANSACTION;
   9
  10 -- PERMISSION TYPES --------------------------------------------------------------------------------
  11 INSERT OR IGNORE INTO permission_type(type_name) VALUES("ALL_APPS"); -- Automatically added to all apps.
  12 INSERT OR IGNORE INTO permission_type(type_name) VALUES("WRT");
  13 INSERT OR IGNORE INTO permission_type(type_name) VALUES("OSP");
  14 INSERT OR IGNORE INTO permission_type(type_name) VALUES("EFL");
  15 INSERT OR IGNORE INTO permission_type(type_name) VALUES("WRT_partner");
  16 INSERT OR IGNORE INTO permission_type(type_name) VALUES("WRT_platform");
  17 INSERT OR IGNORE INTO permission_type(type_name) VALUES("OSP_partner");
  18 INSERT OR IGNORE INTO permission_type(type_name) VALUES("OSP_platform");
  19
  20 -- APP PATH TYPES ----------------------------------------------------------------------------------
  21 INSERT OR IGNORE INTO app_path_type(name) VALUES("PRIVATE");
  22 INSERT OR IGNORE INTO app_path_type(name) VALUES("GROUP_RW");
  23 INSERT OR IGNORE INTO app_path_type(name) VALUES("PUBLIC_RO");
  24 INSERT OR IGNORE INTO app_path_type(name) VALUES("SETTINGS_RW");
  25 INSERT OR IGNORE INTO app_path_type(name) VALUES("ANY_LABEL");
  26
  27 INSERT OR IGNORE INTO permission_view(name, type_name) VALUES
  28                 ("ALL_APPS",    "ALL_APPS"),
  29                 ("WRT",         "WRT"),
  30                 ("WRT_partner", "WRT_partner"),
  31                 ("WRT_platform","WRT_platform"),
  32                 ("OSP",         "OSP"),
  33                 ("OSP_partner", "OSP_partner"),
  34                 ("OSP_platform","OSP_platform"),
  35                 ("EFL",         "EFL");
  36
  37 -- PUBLIC FOLDERS ----------------------------------------------------------------------------------
  38 -- PUBLIC_RO
  39 INSERT OR IGNORE INTO permission_app_path_type_rule_view(permission_name,
  40                                                          permission_type_name,
  41                                                          app_path_type_name,
  42                                                          access,
  43                                                          is_reverse) VALUES
  44         ("ALL_APPS",    "ALL_APPS",     "PUBLIC_RO", "rx", 0);
  45
  46
  47 -- SETTINGS ----------------------------------------------------------------------------------------
  48 -- Permission name == TIZEN_PRIVILEGE_APPSETTING
  49 -- SETTINGS_RW
  50 INSERT OR IGNORE INTO permission_view(name, type_name) VALUES
  51                 ("org.tizen.privilege.appsetting", "WRT"),
  52                 ("org.tizen.privilege.appsetting", "OSP"),
  53                 ("org.tizen.privilege.appsetting", "EFL");
  54
  55 INSERT OR IGNORE INTO permission_app_path_type_rule_view(permission_name,
  56                                                          permission_type_name,
  57                                                          app_path_type_name,
  58                                                          access,
  59                                                          is_reverse) VALUES
  60         ("org.tizen.privilege.appsetting","WRT", "SETTINGS_RW", "rwx", 0),
  61         ("org.tizen.privilege.appsetting","OSP", "SETTINGS_RW", "rwx", 0),
  62         ("org.tizen.privilege.appsetting","EFL", "SETTINGS_RW", "rwx", 0);
  63
  64 INSERT OR IGNORE INTO permission_permission_rule_view(permission_name,
  65                                                       permission_type_name,
  66                                                       target_permission_name,
  67                                                       target_permission_type_name,
  68                                                       access,
  69                                                       is_reverse) VALUES
  70         ("org.tizen.privilege.appsetting","WRT", "ALL_APPS", "ALL_APPS", "rx", 0),
  71         ("org.tizen.privilege.appsetting","OSP", "ALL_APPS", "ALL_APPS", "rx", 0),
  72         ("org.tizen.privilege.appsetting","EFL", "ALL_APPS", "ALL_APPS", "rx", 0);
  73
  74
  75 -- ANTIVIRUS ---------------------------------------------------------------------------------------
  76 -- Permission name == TIZEN_PRIVILEGE_ANTIVIRUS
  77 INSERT OR IGNORE INTO permission_view(name, type_name) VALUES
  78                 ("org.tizen.privilege.antivirus", "WRT"),
  79                 ("org.tizen.privilege.antivirus", "OSP"),
  80                 ("org.tizen.privilege.antivirus", "EFL");
  81
  82 INSERT OR IGNORE INTO permission_permission_rule_view(permission_name,
  83                                                       permission_type_name,
  84                                                       target_permission_name,
  85                                                       target_permission_type_name,
  86                                                       access,
  87                                                       is_reverse) VALUES
  88         ("org.tizen.privilege.antivirus","WRT", "ALL_APPS", "ALL_APPS", "rwx", 0),
  89         ("org.tizen.privilege.antivirus","OSP", "ALL_APPS", "ALL_APPS", "rwx", 0),
  90         ("org.tizen.privilege.antivirus","EFL", "ALL_APPS", "ALL_APPS", "rwx", 0);
  91
  92 INSERT OR IGNORE INTO permission_app_path_type_rule_view(permission_name,
  93                                                          permission_type_name,
  94                                                          app_path_type_name,
  95                                                          access,
  96                                                          is_reverse) VALUES
  97         ("org.tizen.privilege.antivirus","WRT", "GROUP_RW",    "rwx", 0),
  98         ("org.tizen.privilege.antivirus","OSP", "GROUP_RW",    "rwx", 0),
  99         ("org.tizen.privilege.antivirus","EFL", "GROUP_RW",    "rwx", 0),
 100         ("org.tizen.privilege.antivirus","WRT", "SETTINGS_RW", "rwx", 0),
 101         ("org.tizen.privilege.antivirus","OSP", "SETTINGS_RW", "rwx", 0),
 102         ("org.tizen.privilege.antivirus","EFL", "SETTINGS_RW", "rwx", 0),
 103         ("org.tizen.privilege.antivirus","WRT", "PUBLIC_RO",   "rwx", 0),
 104         ("org.tizen.privilege.antivirus","OSP", "PUBLIC_RO",   "rwx", 0),
 105         ("org.tizen.privilege.antivirus","EFL", "PUBLIC_RO",   "rwx", 0),
 106         ("org.tizen.privilege.antivirus","WRT", "ANY_LABEL",   "rwx", 0),
 107         ("org.tizen.privilege.antivirus","OSP", "ANY_LABEL",   "rwx", 0),
 108         ("org.tizen.privilege.antivirus","EFL", "ANY_LABEL",   "rwx", 0);
 109
 110
 111 -- Initial fill of all_smack_binary_rules table
 112 DELETE FROM all_smack_binary_rules;
 113 INSERT INTO all_smack_binary_rules
 114 SELECT      subject, object, access, is_volatile
 115 FROM        all_smack_binary_rules_view;
 116
 117 COMMIT TRANSACTION;