Bug 300625 - Add password protecting to Kexi database files
Summary: Add password protecting to Kexi database files
Status: ASSIGNED
Alias: None
Product: KEXI
Classification: Applications
Component: General (show other bugs)
Version: unspecified
Platform: Compiled Sources All
: NOR wishlist
Target Milestone: ---
Assignee: Wojciech Kosowicz
URL: https://community.kde.org/Kexi/Securi...
Keywords:
Depends on:
Blocks: 300626
  Show dependency treegraph
 
Reported: 2012-05-25 20:12 UTC by jmadero
Modified: 2015-01-08 10:21 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.