X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=tests%2Fsecurity-manager-tests%2Fcommon%2Fsm_db.cpp;h=8e3e56221fb03b1e46e2477c80edc8caabf2e786;hb=a07c65e735f85a7817c7a762d57d25849a2bf9ab;hp=2f420bf09d9a707ecc7636405bb9432c1ed2ef65;hpb=af544bd0c0ccc5f901a719a0f1b3ae599c214730;p=platform%2Fcore%2Ftest%2Fsecurity-tests.git

diff --git a/tests/security-manager-tests/common/sm_db.cpp b/tests/security-manager-tests/common/sm_db.cpp
index 2f420bf..8e3e562 100644
--- a/tests/security-manager-tests/common/sm_db.cpp
+++ b/tests/security-manager-tests/common/sm_db.cpp
@@ -187,15 +187,13 @@ void TestSecurityManagerDatabase::setup_privilege_groups(const std::string &priv
     if (!m_base.is_open())
         m_base.open();
 
-    sql << "INSERT OR IGNORE INTO privilege (name) VALUES ('" << privilege << "')";
-    m_base.execute(sql.str(), result);
-
     for (const auto &group : groups) {
         sql.clear();
         sql.str("");
-        sql << "INSERT OR IGNORE INTO privilege_group (privilege_id, name) "
-               "VALUES ((SELECT privilege_id FROM privilege WHERE name = '"
-                << privilege << "'), '" << group << "')";
+        sql << "INSERT INTO privilege_group_view (privilege_name, group_name) "
+               "VALUES ("
+                << "'" << privilege << "'" << ","
+                << "'" << group << "'" << ")";
         m_base.execute(sql.str(), result);
     }
 }