Thinking about security, and minimizing problems if someone unauthorized can gain remote access to the database server, I thought about encrypting the critical data.
Critical (customer-defined) data examples:
- Credit card number: string;
- Credit card security code: integer;
- Wages: currency;
- Company name: string;
- CPNJ: string;
- Full name: string;
- CPF: string;
- Revenue values: currency;
- Receipt dates: currency;
But it would not be viable if you lost features in the encrypted fields like:
- order by CAMPO_CRIPTOGRAFADO
- group by CAMPO_CRIPTOGRAFADO
- where / having CAMP_CRIPTOGRAPHED like 'AB%'
- where / having CAMP_CRIPTOGRAPHED between 50 and 56
- where / having CAMP_CRIPTOGRAPH between '2016-01-01' and '2016-01-31'
- where / having FILE_CRIPTOGRAPHY > 23
- where / having FILE_CRIPTOGRAPHED < '2016-01-01'
Is there a relational database, preferably freeware , that supports field encryption without losing the above features?