sl@0: // Copyright (c) 2004-2009 Nokia Corporation and/or its subsidiary(-ies).
sl@0: // All rights reserved.
sl@0: // This component and the accompanying materials are made available
sl@0: // under the terms of "Eclipse Public License v1.0"
sl@0: // which accompanies this distribution, and is available
sl@0: // at the URL "http://www.eclipse.org/legal/epl-v10.html".
sl@0: //
sl@0: // Initial Contributors:
sl@0: // Nokia Corporation - initial contribution.
sl@0: //
sl@0: // Contributors:
sl@0: //
sl@0: // Description:
sl@0: // DBMS security policy - testing new APIs.
sl@0: // This test app has "WriteDeviceData" (TABLE B: WRITE) capability, although it does not allows
sl@0: // writing data to table B, because (UID: WRITE) policy is not satisfied.
sl@0: // The UID policy file is 11335579.spd.
sl@0: // The test uses C:TESTDB.DB secure shared database, which has tables A, B and C, each of them
sl@0: // with at least one record.
sl@0: // Please, ensure that t_dbenvcreate test is executed before t_dbplatsec<N>/t_dbplatsecperf tests!
sl@0: // Please, ensure that t_dbenvdestroy test is executed after t_dbplatsec<N>/t_dbplatsecperf tests!
sl@0: // 
sl@0: //
sl@0: 
sl@0: #include <e32test.h>
sl@0: #include <d32dbms.h>
sl@0: #include "t_dbplatsecutl.h"
sl@0: 
sl@0: const TUid KSecureDbUid = {0x11335579};
sl@0: _LIT(KSecure,	"SECURE");
sl@0: _LIT(KDbName,	"C:TestDB.DB");
sl@0: _LIT(KTblNameA,	"A");
sl@0: _LIT(KTblNameB,	"B");
sl@0: _LIT(KTblNameC,	"C");
sl@0: 
sl@0: static RTest 				TheTest(_L("t_dbplatsec4: DBMS platform security testing - 4"));
sl@0: static RDbs 				TheDbs;
sl@0: static RDbNamedDatabase 	TheDb;
sl@0: static RDbTable 			TheTbl;
sl@0: static RDbView 				TheView;
sl@0: 
sl@0: TDBSCUtils 	TheDbscUtils(TheTest, NULL);
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID SYSLIB-DBMS-CT-0017
sl@0: @SYMTestCaseDesc Open table test.
sl@0: 				 This test app has "WriteDeviceData" (TABLE B: WRITE) capability,
sl@0: 				 although it does not allows writing data to table B, because
sl@0: 				 (UID: WRITE) policy is not satisfied. The attempts to open database
sl@0: 				 tables in insert/update mode must fail.
sl@0: @SYMTestPriority High
sl@0: @SYMTestActions  Open table test.
sl@0: @SYMTestExpectedResults The test must not fail.
sl@0: @SYMREQ REQ2429
sl@0:                  DBMS shall provide an API to apply security policies to database tables.
sl@0: */
sl@0: static void TblTestL()
sl@0: 	{
sl@0: 	TheTest.Printf(_L("An attempt to open table A\n"));
sl@0: 	//The test must fail, because the test app cannot satisfy table A, policy W.
sl@0: 	TInt err = TheTbl.Open(TheDb, KTblNameA);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 	//The test must fail, because the test app cannot satisfy table A, policy R.
sl@0: 	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EReadOnly);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 
sl@0: 	TheTest.Printf(_L("An attempt to open table B\n"));
sl@0: 	//The test must fail, because the test app cannot satisfy table B, policy W.
sl@0: 	err = TheTbl.Open(TheDb, KTblNameB);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 	//The test must pass, because table B has no R policy.
sl@0: 	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EReadOnly);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheTbl.Close();
sl@0: 
sl@0: 	TheTest.Printf(_L("An attempt to write to table B\n"));
sl@0: 	//The test must fail, because the test app cannot satisfy table B, policy W.
sl@0: 	err = TheDb.Execute(_L("UPDATE B SET DATA1 = 400 WHERE ID < 10"));
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 
sl@0: 	TheTest.Printf(_L("An attempt to open table C\n"));
sl@0: 	//The test must fail, because the test app cannot satisfy table C, policy W.
sl@0: 	err = TheTbl.Open(TheDb, KTblNameC);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 	//The test must pass, because table C has no R policy.
sl@0: 	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EReadOnly);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheTbl.Close();
sl@0: 	}
sl@0: 
sl@0: static void DoRunL()
sl@0: 	{
sl@0: 	TheTest.Start(_L("An app with \"TABLE B:WRITE\" capabilities set"));
sl@0: 
sl@0: 	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0017 Tble tests "));
sl@0: 	::TblTestL();
sl@0: 	}
sl@0: 
sl@0: TInt E32Main()
sl@0:     {
sl@0: 	__UHEAP_MARK;
sl@0: 	CTrapCleanup* tc = CTrapCleanup::New();
sl@0: 	TEST(tc != NULL);
sl@0: 
sl@0: 	TInt err = TheDbs.Connect();
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	TBuf<32> format;
sl@0: 	TheTest.Printf(_L("Open database\n"));
sl@0: 	format.Copy(KSecure);
sl@0: 	format.Append(KSecureDbUid.Name());
sl@0: 	err = TheDb.Open(TheDbs, KDbName, format);
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	TRAP(err, ::DoRunL());
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	TheView.Close();
sl@0: 	TheTbl.Close();
sl@0: 	TheDb.Close();
sl@0: 	TheDbs.Close();
sl@0: 
sl@0: 	TheTest.End();
sl@0: 	TheTest.Close();
sl@0: 
sl@0: 	delete tc;
sl@0: 
sl@0: 	__UHEAP_MARKEND;
sl@0: 	User::Heap().Check();
sl@0: 	return KErrNone;
sl@0:     }