102 TEST2(err, KErrNone); |
102 TEST2(err, KErrNone); |
103 |
103 |
104 //Attempt to modify the database schema |
104 //Attempt to modify the database schema |
105 err = TheDb.Exec(_L("CREATE TABLE C(FFF TEXT)")); |
105 err = TheDb.Exec(_L("CREATE TABLE C(FFF TEXT)")); |
106 TEST2(err, KErrPermissionDenied); |
106 TEST2(err, KErrPermissionDenied); |
|
107 err = TheDb.Exec(_L("CREATE TRIGGER upd_a_b1 UPDATE OF B1 ON A BEGIN UPDATE B SET F3 = 'AAAA' WHERE F2 = A.F1; END;")); |
|
108 TEST2(err, KErrPermissionDenied); |
|
109 err = TheDb.Exec(_L("CREATE TEMP TRIGGER upd_a_b1 UPDATE OF B1 ON A BEGIN UPDATE B SET F3 = 'AAAA' WHERE F2 = A.F1; END;")); |
|
110 TEST2(err, KErrPermissionDenied);//Temp trigger which attempts to update one of the tables. |
|
111 err = TheDb.Exec(_L("CREATE VIEW V1 AS SELECT * FROM A")); |
|
112 TEST2(err, KErrPermissionDenied); |
|
113 err = TheDb.Exec(_L("CREATE TEMP VIEW V1 AS SELECT * FROM A")); |
|
114 TEST(err >= 0); |
|
115 err = TheDb.Exec(_L("DROP VIEW V1")); |
|
116 TEST(err >= 0); |
107 //Attempt to update the user data (but it includes a READ operation) |
117 //Attempt to update the user data (but it includes a READ operation) |
108 err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1")); |
118 err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1")); |
109 TEST2(err, KErrPermissionDenied); |
119 TEST2(err, KErrPermissionDenied); |
110 //Attempt to update the user data (unconditional UPDATE, no READ operations) |
120 //Attempt to update the user data (unconditional UPDATE, no READ operations) |
111 err = TheDb.Exec(_L("UPDATE A SET F1 = 11")); |
121 err = TheDb.Exec(_L("UPDATE A SET F1 = 11")); |