Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10702

Re: Encrypting data in DBF file

Path csiph.com!eternal-september.org!feeder.eternal-september.org!border1.nntp.ams1.giganews.com!nntp.giganews.com!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer04.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Urs Eggmann" <Urs.Eggmann@shinternet.ch>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Encrypting data in DBF file
Date Mon, 19 Jun 2017 22:46:27 +0200
Lines 60
Message-ID <eqqrhdFm72sU2@mid.individual.net> (permalink)
References <691ec839-e8ee-4a71-a067-a8c4e1ca70b3@googlegroups.com> <8ae5a1da-1714-4c1f-ae44-6a200adaa7c6@googlegroups.com> <59280bd0-b66a-4026-b67a-e51d289db700@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; format=flowed; charset="utf-8"; reply-type=original
Content-Transfer-Encoding 7bit
X-Trace individual.net xmUKSnw6Sz1aMIqaYiMQAgzw+w+yD1OByMxZvg5AzZjs44nGR4
Cancel-Lock sha1:nkRf5zCRAld0n/oF7lJQplJZ780=
X-Priority 3
X-MSMail-Priority Normal
X-Newsreader Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE Produced By Microsoft MimeOLE V6.00.2900.6157
X-EsetId 37303A29ABFDDD64627265
X-EsetScannerBuild 33776
X-Received-Bytes 3043
X-Received-Body-CRC 484457473
Xref csiph.com comp.lang.clipper.visual-objects:10702

Show key headers only | View raw


Hi Simon,

On t h website of the user group Bodensee ( www.voug-bodensee.net )  you can 
find two samples for encrypting db files:
CryptoFalle.zip   And  CryptDB.zip

A trap you can fall in are the blanks at the end of a field content. If you 
encrypt a string, that is shorter as the field length, the blanks at the end 
are also encrypted and savet to the field. On decryption of e fieldcontent, 
the resulting string contains blanks.

regards
Urs


<simon@abersoftware.co.uk> schrieb im Newsbeitrag 
news:59280bd0-b66a-4026-b67a-e51d289db700@googlegroups.com...
> On Monday, June 19, 2017 at 3:32:31 PM UTC+1, dlzc wrote:
>> Dear si...:
>>
>> On Monday, June 19, 2017 at 1:52:44 AM UTC-7, si...@abersoftware.co.uk 
>> wrote:
>> ...
>> > Anyone have any thoughts on best way to encrypt data
>> > fields that are stored in DBF file.
>> >
>> > The reason is just to stop people looking at the DBF
>> > file from outside the application.
>>
>> Move from DBF to SQL.
>> ... or ...
>> Move DBF to server, and only provide access to the DBF data via Terminal 
>> Services.
>> ... or ...
>> Use the methods of a hierarchical database, and keep data in several 
>> different "synced" data files.
>> ... or ...
>> Can also copy/move/reattrib the DBF from a hidden directory or state, as 
>> the first step in program execution, while your splash screen displays.
>>
>> ... for "lightweight" (non run-time intensive) methods.
>>
>> David A. Smith
> Hi David,
>
> I like the idea of the hidden file but want to keep installation and setup 
> as simple as possible.
>
> Moving to SQL would be nice but no time at the moment. Will switch 
> eventually though.
>
> Having the field encrypted in the datafile gives some level of protection 
> and if the IT people secure their systems properly then will be fine for 
> my case.
>
> I just need to test on a few different systems to make sure it doesn't 
> mess up with different character sets / conversions etc.
>
> Simon 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Encrypting data in DBF file simon@abersoftware.co.uk - 2017-06-19 01:52 -0700
  Re: Encrypting data in DBF file "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-06-19 11:34 +0200
  Re: Encrypting data in DBF file simon@abersoftware.co.uk - 2017-06-19 03:25 -0700
    Re: Encrypting data in DBF file "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-06-19 14:01 +0200
      Re: Encrypting data in DBF file simon@abersoftware.co.uk - 2017-06-19 05:38 -0700
  Re: Encrypting data in DBF file JohnMartens <martens@tennishulp.info> - 2017-06-19 14:02 +0200
    Re: Encrypting data in DBF file simon@abersoftware.co.uk - 2017-06-19 05:47 -0700
  Re: Encrypting data in DBF file dlzc <dlzc1@cox.net> - 2017-06-19 07:32 -0700
    Re: Encrypting data in DBF file simon@abersoftware.co.uk - 2017-06-19 09:15 -0700
      Re: Encrypting data in DBF file "Urs Eggmann" <Urs.Eggmann@shinternet.ch> - 2017-06-19 22:46 +0200
  Re: Encrypting data in DBF file "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2017-06-20 08:24 +0000
  Re: Encrypting data in DBF file Martin <Martin@spam.spam> - 2017-06-26 09:27 +0100
  Re: Encrypting data in DBF file simon@abersoftware.co.uk - 2017-07-17 13:30 -0700

csiph-web