|
|
|
|
| Re: What encryption algorithm Oracle 12 [message #669251 is a reply to message #669249] |
Tue, 10 April 2018 00:59   |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
You need to be running Oracle Enterprise Edition with the Advanced Security Option (a cost option) to encrypt data in Oracle.
Different encryption algorithms are supported, like AES256, AES192 (default for column encryption), AES128 (default for tablespace encryption), and 3DES168.
The encryption keys (I assume this is what you mean by digital signatures) are stored in a wallet. The wallet is also encrypted and password protected. If I understand correctly, it uses 3DES or AES.
|
|
|
|
|
|
| Re: What encryption algorithm Oracle 12 [message #669257 is a reply to message #669248] |
Tue, 10 April 2018 08:58 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
You can encrypt programmatically without ASO (and in Standard Edition), using the dbms_crypto package. Several times I have set up transparent encryption with this. You cover your table with a view, and use functions in INSTEAD OF triggers to encrypt the data when writing and functions in the view definition to decrypt the data when reading. It works. You do need to suss out a way to store and retrieve the keys. Context variables are one method.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
