Bug 300625

Summary:	Add password protecting to Kexi database files
Product:	[Applications] KEXI	Reporter:	jmadero
Component:	General	Assignee:	Wojciech Kosowicz <pcellix>
Status:	ASSIGNED ---
Severity:	wishlist	CC:	pcellix, staniek
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	Compiled Sources
OS:	All
URL:	https://community.kde.org/Kexi/Security/Add_password_protecting_to_Kexi_database_files
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Bug Depends on:
Bug Blocks:	300626

Description jmadero 2012-05-25 20:12:52 UTC

Adding the ability to include a password on opening a kexi database would be great. Many times we share our systems but only want a limited amount of people to have access to our databases. 

Thanks for the hard work

Reproducible: Always

Comment 1 Jarosław Staniek 2012-05-25 21:59:13 UTC

There is also related wish https://bugs.kde.org/show_bug.cgi?id=300625 "Add password protecting to individual objects in Kexi ".

Comment 2 Jarosław Staniek 2012-05-25 22:00:23 UTC

I meant https://bugs.kde.org/show_bug.cgi?id=300626.

Comment 3 Wojciech Kosowicz 2014-09-25 20:26:18 UTC

dips on that :) looks like fun :)

Comment 4 Jarosław Staniek 2014-09-25 21:49:46 UTC

Yep, fun. We need to take some time to design this and consider security. And tools to use for encrypting. Looking at how people do that with SQLite 3 is welcome (ideally: at record level, incrementally).

And, I just extended the area of discussion, since as soon as we take the user's goals, we observe that it *may be* not about password protecting:
https://forum.kde.org/viewtopic.php?f=221&t=102232&p=320343#p320343

That said, password protecting is a valid task.

Comment 5 jmadero 2014-09-28 04:15:32 UTC

Maybe look at how LibreOffice does it - not sure about your license but if it's compatible might not need to redesign from scratch :-D

Comment 6 Jarosław Staniek 2014-09-29 08:05:34 UTC

@jmadero Good hint. Always good to look around. There are differences: LibreOffice does not use "standard" file, it's compressed Java-based HyperSQL, instead of "standard" SQLite. 
We want to combine password-protecting with encrypting I think?  Then we'll also look at full encrypting of SQLite.

Comment 7 Jarosław Staniek 2014-09-29 23:14:47 UTC

Design page would be at: https://community.kde.org/Kexi/Security/Add_password_protecting_to_Kexi_database_files

Comment 8 Jarosław Staniek 2015-01-08 06:54:24 UTC

@Wojciech Now that you're busy with porting I propose to leave this development as unassigned again.