Home » RDBMS Server » Security » What encryption algorithm Oracle 12 (RDBMS 12.1..0.2 on linux)
What encryption algorithm Oracle 12 [message #669248] Mon, 09 April 2018 14:04 Go to next message
evoradba
Messages: 112
Registered: April 2005
Location: Canada
Senior Member

What encryption algorithm Oracle 12 for the
1) the data
2) the digital signatures


Many thanks
Maria
Re: What encryption algorithm Oracle 12 [message #669249 is a reply to message #669248] Mon, 09 April 2018 14:54 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
evoradba wrote on Mon, 09 April 2018 12:04

What encryption algorithm Oracle 12 for the
1) the data
2) the digital signatures


Many thanks
Maria
1) not encrypted by default
2) what digital signatures?


Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
Re: What encryption algorithm Oracle 12 [message #669251 is a reply to message #669249] Tue, 10 April 2018 00:59 Go to previous messageGo to next message
Frank Naude
Messages: 4561
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 #669254 is a reply to message #669251] Tue, 10 April 2018 07:40 Go to previous messageGo to next message
evoradba
Messages: 112
Registered: April 2005
Location: Canada
Senior Member
thank you
Re: What encryption algorithm Oracle 12 [message #669257 is a reply to message #669248] Tue, 10 April 2018 08:58 Go to previous message
John Watson
Messages: 8085
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.
Previous Topic: Regarding oracle VPD
Next Topic: synonym how get info on how user has access to it
Goto Forum:
  


Current Time: Sat Dec 14 13:16:41 CST 2019