Sven Vogler wrote: > Does it give to the SAP-DB the possibility of encoding zumindestens > some fields (for the programmer (PHP or Java) and the user > transparency) > > The SAP-DB possesses an interface too crypto libs. in the operating > system (Linux) or there are experiences with the merging of these > external programs (- > performance)? Which interface can one > recommend for it? > > If the solution is situated in the programming of a procedure, are > there example solutions for it? > > any hints? > > (translate by altavista)
for english list-members: zumindestens means 'at least' The database kernel does not have such an interface and even changing some database fields using a dbprocedure will be no solution. As far as we see it here, writing a C-application, crypting the fields in this application and using CHAR (n) BYTE for those crypted fields is the only way you have. It should be clear that, if you crypt some fields, normal WHERE field = <value> is only possible if value is given in crypted form and >, <, BETWEEN, LIKE are of no use any more for those crypted fields. And ORDER BY may result in unexpected (because in crypted form) ordering. Sorry, not to be able to have better news. Elke SAP Labs Berlin