security...
security...
It´s possible, core lad´s developers, add suport to encriptation data
example: setting the property Encript in the Query, all data is encripted on insert and all data is decripted on selec,, for protect the database.
it´s possible?
sorry my bad english.
example: setting the property Encript in the Query, all data is encripted on insert and all data is decripted on selec,, for protect the database.
it´s possible?
sorry my bad english.
encrypted data not encrypted connection....
I suggest a property for encrypted Rows.
example:
setting the "supost" property encryt on TmyQuery
and setting
SQL > Insert into TblNames (Name) values (:name )
with myQuery do begin
Parambyname( 'Name' ).AsString := 'Eduardo S Santos from Brazil';
Execute;
end;
The value for Field "Name" is inserted in the table, but was encripted...
when execute a select ... the TmyQuery , decript and show the row..
resuming:
TmyQuery ofers support a encriptation/decriptation for Rows....
understand?
Thanks, Eduardo S Santos.
example:
setting the "supost" property encryt on TmyQuery
and setting
SQL > Insert into TblNames (Name) values (:name )
with myQuery do begin
Parambyname( 'Name' ).AsString := 'Eduardo S Santos from Brazil';
Execute;
end;
The value for Field "Name" is inserted in the table, but was encripted...
when execute a select ... the TmyQuery , decript and show the row..
resuming:
TmyQuery ofers support a encriptation/decriptation for Rows....
understand?
Thanks, Eduardo S Santos.
Local Security...
Paul, i don´t talking about SSL, i asking if its possible core labs Add suport
for a Rows encriptation...
I can send a simple program for explain the sugestion?
this feature is important for protect a comercial database.
more one example
Insert Operation
|User front-end Data| >> |TmyQuery with encriptation| >> | Encrited data in mySQL table|
select Operation
|User front-end Data| << |TmyQuery with decriptation| << | Encrited data in mySQL table|
Thanks, Eduardo.
for a Rows encriptation...
I can send a simple program for explain the sugestion?
this feature is important for protect a comercial database.
more one example
Insert Operation
|User front-end Data| >> |TmyQuery with encriptation| >> | Encrited data in mySQL table|
select Operation
|User front-end Data| << |TmyQuery with decriptation| << | Encrited data in mySQL table|
Thanks, Eduardo.
I would say you're looking for some functionality of MySQL itself, not the components. For encripting data into db and decrypting in selects you must use MySQL's encrypt/decrypt functions. Look at this chapter of MySQL manual:
http://dev.mysql.com/doc/mysql/en/encry ... tions.html
http://dev.mysql.com/doc/mysql/en/encry ... tions.html
eduardosic, good question!
To CoreLabTeam:
What about encryption data for local databases (embedded server)? For example, I make database with commercial data (big list of enterprises - 1 million records) and I want protect this data from external use (passing over my interface).
Is any solutions?
Also request: compressing blobs for all *Dac products. Now I use external Zlib library for this aim.
Thank you!
To CoreLabTeam:
What about encryption data for local databases (embedded server)? For example, I make database with commercial data (big list of enterprises - 1 million records) and I want protect this data from external use (passing over my interface).
Is any solutions?
Also request: compressing blobs for all *Dac products. Now I use external Zlib library for this aim.
Thank you!
This issue concerns most likely MySQL than MyDAC. Implementation of reliable encryption of stored data at the level of client is almost impossible.
Developers of servers (MySQL, MS SQL, Oracle etc) usually assume that data will be stored at the protected disk at the server. Certainly for MySQL Embedded Server it is can be realized rather difficult.
Try to use protected virtual disks like PGP or ask MySQL AB to add this functionality at the next server versions.
Developers of servers (MySQL, MS SQL, Oracle etc) usually assume that data will be stored at the protected disk at the server. Certainly for MySQL Embedded Server it is can be realized rather difficult.
Try to use protected virtual disks like PGP or ask MySQL AB to add this functionality at the next server versions.