persistentstorage/sql/TEST/t_sqlsecurity2.cpp
changeset 15 3eacc0623088
parent 0 08ec8eefde2f
child 55 44f437012c90
equal deleted inserted replaced
14:15018f1726c7 15:3eacc0623088
    94 	TEST2(err, KErrNone);
    94 	TEST2(err, KErrNone);
    95 	
    95 	
    96 	//Attempt to modify the database schema
    96 	//Attempt to modify the database schema
    97 	err = TheDb.Exec(_L("CREATE TABLE C(FFF TEXT)"));
    97 	err = TheDb.Exec(_L("CREATE TABLE C(FFF TEXT)"));
    98 	TEST2(err, KErrPermissionDenied);
    98 	TEST2(err, KErrPermissionDenied);
       
    99     err = TheDb.Exec(_L("CREATE TEMP TABLE TBL100(COL1 INTEGER)"));
       
   100     TEST(err >= 0);
       
   101     err = TheDb.Exec(_L("CREATE INDEX IDX100 ON TBL100(COL1)"));
       
   102     TEST(err >= 0);
       
   103     err = TheDb.Exec(_L("DROP INDEX IDX100"));
       
   104     TEST(err >= 0);
       
   105     err = TheDb.Exec(_L("DROP TABLE TBL100"));
       
   106     TEST(err >= 0);
    99 	//Attempt to update the user data
   107 	//Attempt to update the user data
   100 	err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1"));
   108 	err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1"));
   101 	TEST2(err, KErrPermissionDenied);
   109 	TEST2(err, KErrPermissionDenied);
   102 	//Attempt to delete the user data
   110 	//Attempt to delete the user data
   103 	err = TheDb.Exec(_L("DELETE FROM B WHERE F2 = 2"));
   111 	err = TheDb.Exec(_L("DELETE FROM B WHERE F2 = 2"));