persistentstorage/sql/TEST/t_sqlsecurity2.cpp
branchRCL_3
changeset 8 fa9941cf3867
parent 0 08ec8eefde2f
--- a/persistentstorage/sql/TEST/t_sqlsecurity2.cpp	Sat Feb 20 00:33:55 2010 +0200
+++ b/persistentstorage/sql/TEST/t_sqlsecurity2.cpp	Fri Mar 12 15:51:02 2010 +0200
@@ -96,6 +96,14 @@
 	//Attempt to modify the database schema
 	err = TheDb.Exec(_L("CREATE TABLE C(FFF TEXT)"));
 	TEST2(err, KErrPermissionDenied);
+    err = TheDb.Exec(_L("CREATE TEMP TABLE TBL100(COL1 INTEGER)"));
+    TEST(err >= 0);
+    err = TheDb.Exec(_L("CREATE INDEX IDX100 ON TBL100(COL1)"));
+    TEST(err >= 0);
+    err = TheDb.Exec(_L("DROP INDEX IDX100"));
+    TEST(err >= 0);
+    err = TheDb.Exec(_L("DROP TABLE TBL100"));
+    TEST(err >= 0);
 	//Attempt to update the user data
 	err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1"));
 	TEST2(err, KErrPermissionDenied);