OraFAQ Forum: Security » What encryption algorithm Oracle 12

Home » RDBMS Server » Security » What encryption algorithm Oracle 12 (RDBMS 12.1..0.2 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What encryption algorithm Oracle 12 [message #669248]

Mon, 09 April 2018 14:04

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

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

Many thanks
Maria

Report message to a moderator

Re: What encryption algorithm Oracle 12 [message #669249 is a reply to message #669248]

Mon, 09 April 2018 14:54

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: What encryption algorithm Oracle 12 [message #669251 is a reply to message #669249]

Tue, 10 April 2018 00:59

Frank Naude
Messages: 4596
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.

Report message to a moderator

Re: What encryption algorithm Oracle 12 [message #669254 is a reply to message #669251]

Tue, 10 April 2018 07:40

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

thank you

Report message to a moderator

Re: What encryption algorithm Oracle 12 [message #669257 is a reply to message #669248]

Tue, 10 April 2018 08:58

John Watson
Messages: 8976
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.

Report message to a moderator

Previous Topic:	Regarding oracle VPD
Next Topic:	synonym how get info on how user has access to it

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 20:04:13 CDT 2025