1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dbplatsec4.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,131 @@
1.4 +// Copyright (c) 2004-2009 Nokia Corporation and/or its subsidiary(-ies).
1.5 +// All rights reserved.
1.6 +// This component and the accompanying materials are made available
1.7 +// under the terms of "Eclipse Public License v1.0"
1.8 +// which accompanies this distribution, and is available
1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
1.10 +//
1.11 +// Initial Contributors:
1.12 +// Nokia Corporation - initial contribution.
1.13 +//
1.14 +// Contributors:
1.15 +//
1.16 +// Description:
1.17 +// DBMS security policy - testing new APIs.
1.18 +// This test app has "WriteDeviceData" (TABLE B: WRITE) capability, although it does not allows
1.19 +// writing data to table B, because (UID: WRITE) policy is not satisfied.
1.20 +// The UID policy file is 11335579.spd.
1.21 +// The test uses C:TESTDB.DB secure shared database, which has tables A, B and C, each of them
1.22 +// with at least one record.
1.23 +// Please, ensure that t_dbenvcreate test is executed before t_dbplatsec<N>/t_dbplatsecperf tests!
1.24 +// Please, ensure that t_dbenvdestroy test is executed after t_dbplatsec<N>/t_dbplatsecperf tests!
1.25 +//
1.26 +//
1.27 +
1.28 +#include <e32test.h>
1.29 +#include <d32dbms.h>
1.30 +#include "t_dbplatsecutl.h"
1.31 +
1.32 +const TUid KSecureDbUid = {0x11335579};
1.33 +_LIT(KSecure, "SECURE");
1.34 +_LIT(KDbName, "C:TestDB.DB");
1.35 +_LIT(KTblNameA, "A");
1.36 +_LIT(KTblNameB, "B");
1.37 +_LIT(KTblNameC, "C");
1.38 +
1.39 +static RTest TheTest(_L("t_dbplatsec4: DBMS platform security testing - 4"));
1.40 +static RDbs TheDbs;
1.41 +static RDbNamedDatabase TheDb;
1.42 +static RDbTable TheTbl;
1.43 +static RDbView TheView;
1.44 +
1.45 +TDBSCUtils TheDbscUtils(TheTest, NULL);
1.46 +
1.47 +/**
1.48 +@SYMTestCaseID SYSLIB-DBMS-CT-0017
1.49 +@SYMTestCaseDesc Open table test.
1.50 + This test app has "WriteDeviceData" (TABLE B: WRITE) capability,
1.51 + although it does not allows writing data to table B, because
1.52 + (UID: WRITE) policy is not satisfied. The attempts to open database
1.53 + tables in insert/update mode must fail.
1.54 +@SYMTestPriority High
1.55 +@SYMTestActions Open table test.
1.56 +@SYMTestExpectedResults The test must not fail.
1.57 +@SYMREQ REQ2429
1.58 + DBMS shall provide an API to apply security policies to database tables.
1.59 +*/
1.60 +static void TblTestL()
1.61 + {
1.62 + TheTest.Printf(_L("An attempt to open table A\n"));
1.63 + //The test must fail, because the test app cannot satisfy table A, policy W.
1.64 + TInt err = TheTbl.Open(TheDb, KTblNameA);
1.65 + TEST2(err, KErrPermissionDenied);
1.66 + //The test must fail, because the test app cannot satisfy table A, policy R.
1.67 + err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EReadOnly);
1.68 + TEST2(err, KErrPermissionDenied);
1.69 +
1.70 + TheTest.Printf(_L("An attempt to open table B\n"));
1.71 + //The test must fail, because the test app cannot satisfy table B, policy W.
1.72 + err = TheTbl.Open(TheDb, KTblNameB);
1.73 + TEST2(err, KErrPermissionDenied);
1.74 + //The test must pass, because table B has no R policy.
1.75 + err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EReadOnly);
1.76 + TEST2(err, KErrNone);
1.77 + TheTbl.Close();
1.78 +
1.79 + TheTest.Printf(_L("An attempt to write to table B\n"));
1.80 + //The test must fail, because the test app cannot satisfy table B, policy W.
1.81 + err = TheDb.Execute(_L("UPDATE B SET DATA1 = 400 WHERE ID < 10"));
1.82 + TEST2(err, KErrPermissionDenied);
1.83 +
1.84 + TheTest.Printf(_L("An attempt to open table C\n"));
1.85 + //The test must fail, because the test app cannot satisfy table C, policy W.
1.86 + err = TheTbl.Open(TheDb, KTblNameC);
1.87 + TEST2(err, KErrPermissionDenied);
1.88 + //The test must pass, because table C has no R policy.
1.89 + err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EReadOnly);
1.90 + TEST2(err, KErrNone);
1.91 + TheTbl.Close();
1.92 + }
1.93 +
1.94 +static void DoRunL()
1.95 + {
1.96 + TheTest.Start(_L("An app with \"TABLE B:WRITE\" capabilities set"));
1.97 +
1.98 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0017 Tble tests "));
1.99 + ::TblTestL();
1.100 + }
1.101 +
1.102 +TInt E32Main()
1.103 + {
1.104 + __UHEAP_MARK;
1.105 + CTrapCleanup* tc = CTrapCleanup::New();
1.106 + TEST(tc != NULL);
1.107 +
1.108 + TInt err = TheDbs.Connect();
1.109 + TEST2(err, KErrNone);
1.110 +
1.111 + TBuf<32> format;
1.112 + TheTest.Printf(_L("Open database\n"));
1.113 + format.Copy(KSecure);
1.114 + format.Append(KSecureDbUid.Name());
1.115 + err = TheDb.Open(TheDbs, KDbName, format);
1.116 + TEST2(err, KErrNone);
1.117 +
1.118 + TRAP(err, ::DoRunL());
1.119 + TEST2(err, KErrNone);
1.120 +
1.121 + TheView.Close();
1.122 + TheTbl.Close();
1.123 + TheDb.Close();
1.124 + TheDbs.Close();
1.125 +
1.126 + TheTest.End();
1.127 + TheTest.Close();
1.128 +
1.129 + delete tc;
1.130 +
1.131 + __UHEAP_MARKEND;
1.132 + User::Heap().Check();
1.133 + return KErrNone;
1.134 + }