--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/dbms/tdbms/t_dbnewcap1.cpp	Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,136 @@
+// Copyright (c) 2004-2009 Nokia Corporation and/or its subsidiary(-ies).
+// All rights reserved.
+// This component and the accompanying materials are made available
+// under the terms of "Eclipse Public License v1.0"
+// which accompanies this distribution, and is available
+// at the URL "http://www.eclipse.org/legal/epl-v10.html".
+//
+// Initial Contributors:
+// Nokia Corporation - initial contribution.
+//
+// Contributors:
+//
+// Description:
+//
+
+//The test uses C:TESTDB.DB secure shared database, which creates tables A, B and C.
+#include <e32test.h>
+#include <d32dbms.h>
+#include "t_dbplatsecutl.h"
+
+//The .spd file has the following capabilities:
+//	Schema	None
+//	Read	SurroundingsDD
+//	Write	UserEnvironment
+const TUid KSecureDbUid = {0x12344321};
+
+_LIT(KSecure,	"SECURE");
+_LIT(KDbName,	"C:TestDB.DB");
+_LIT(KTblNameA,	"A");
+_LIT(KTblNameB,	"B");
+_LIT(KTblNameC,	"C");
+
+static RTest 				TheTest(_L("t_dbnewcap1"));
+static RDbs 				TheDbs;
+static RDbNamedDatabase 	TheDb;
+static RDbTable 			TheTbl;
+
+TDBSCUtils 	TheDbscUtils(TheTest, NULL);
+
+static TColDef const KColumns[]=
+	{
+	{_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
+	{_S("DATA1"), EDbColInt32, TDbCol::ENotNull},
+	{_S("DATA2"), EDbColInt32, TDbCol::ENotNull},
+	{0}
+	};
+
+/**
+@SYMTestCaseID SYSLIB-DBMS-CT-1361
+@SYMTestCaseDesc Checking to make sure the .spd file used in this test has been created correctly and
+functions as it should.
+@SYMTestPriority Medium
+@SYMTestActions Creating a database and 3 tables (A, B & C), running 3 actions on it and then deleting
+the database (5 actions in total). Whether the actions are allowed or not is decided on the capabilities
+that the database has (stated in the MMP file) relative to the capabilities that are needed to perform
+certain actions (stated in the .spd file).
+@SYMTestExpectedResults The test must not fail.
+@SYMDEF DEF065282
+*/
+static void DefectTestL()
+	{
+	TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-1361 An app with \"UserEnvironment\" capabilities set\n "));
+
+	TheTest.Printf(_L("Test 1: Create tables\n"));
+	//The tests must pass, because the test app has "SCHEMA" capability
+	CDbColSet* colset = TDBSCUtils::CreateColSetLC(KColumns);
+	TInt err = TheDb.CreateTable(KTblNameA, *colset);
+	TEST2(err, KErrNone);
+	err = TheDb.CreateTable(KTblNameB, *colset);
+	TEST2(err, KErrNone);
+	err = TheDb.CreateTable(KTblNameC, *colset);
+	TEST2(err, KErrNone);
+	CleanupStack::PopAndDestroy(colset);
+
+	TheTest.Printf(_L("Test 2: Opening the tables in insert-only mode\n"));
+	//The tests must pass because the test app has "WRITE" capability
+	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EInsertOnly);
+	TEST2(err, KErrNone);
+	TheTbl.Close();
+	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EInsertOnly);
+	TEST2(err, KErrNone);
+	TheTbl.Close();
+	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EInsertOnly);
+	TEST2(err, KErrNone);
+	TheTbl.Close();
+
+	TheTest.Printf(_L("Test 3: An attempt to open tables in read-only mode\n"));
+	//The tests must not pass because the test app does not have "READ" capability.
+	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EReadOnly);
+	TEST2(err, KErrPermissionDenied);
+	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EReadOnly);
+	TEST2(err, KErrPermissionDenied);
+	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EReadOnly);
+	TEST2(err, KErrPermissionDenied);
+	TheTbl.Close();
+	}
+
+TInt E32Main()
+    {
+	__UHEAP_MARK;
+	CTrapCleanup* tc = CTrapCleanup::New();
+	TEST(tc != NULL);
+
+	TInt err = TheDbs.Connect();
+	TEST2(err, KErrNone);
+
+	TBuf<32> format;
+	format.Copy(KSecure);
+	format.Append(KSecureDbUid.Name());
+
+	//Make sure there is no previous instance of the database.
+	TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
+	TheTest.Printf(_L("Create a database\n"));
+	err = TheDb.Create(TheDbs, KDbName, format);
+	TEST2(err, KErrNone);
+
+	TRAP(err, ::DefectTestL());
+	TEST2(err, KErrNone);
+
+	TheTbl.Close();
+	TheDb.Close();
+	// Remove the database that was created during the tests
+	TheTest.Printf(_L("Delete the database\n"));
+	err = TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
+	TEST2(err, KErrNone);
+	TheDbs.Close();
+
+	TheTest.End();
+	TheTest.Close();
+
+	delete tc;
+
+	__UHEAP_MARKEND;
+	User::Heap().Check();
+	return KErrNone;
+    }