Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Security
Message
De
30/12/2003 06:29:26
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
29/12/2003 18:40:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00862696
Message ID:
00862778
Vues:
16
>Hello There...
>
> First of all, wish a Merry Christmas and a Happy New Year to every member.
>
> I need to implement security mechanism over my tables. I've heard before that every table have a header, and that if someone alterate the header, the table won't work until the values in the header are corrected again. I think this is kind of a cool way to secure our data. The only problem is "How can I edit the values in the header of every table"?
>
> I hope someone knows the answer to this "simple question".
>
>Onelio Dishmey C.
>onedish@hotmail.com

It'd not secure your data. It's easy to create a header for data and read it or directly read using notepad.
If you want just to make a nonworking header simply :

lnHandle = fopen('myDBF.dbf',12)
fwrite(lnHandle,chr(0))
fclose(lnHandle)

It's not a simple question "How can I edit the values in the header of every table"? A simple but cumbersome way would be :

do home()+'tools\hexedit\hexedit' with 'myTable.dbf'

Of course what you want is how to do that programmatically but it doesn't make sense now if it's no good for protection. Protection somewhat depends on what level you want it and a simple one might be to use dbc_events to control opening of tables. Cryptor from www.xitech-europe.co.uk might be another better solution or going to client/server.

Happy new year
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform