oracle - create a master key

Hi experts
how to create a master key?
 I can have multiple master key in a database? I create a table xxx with columns id_aplicacion , master_key where id_aplicacion is unique

I need to read the master key through a web service (passing as parameter the id_application code), as is read the value of a master key?
enrique_aeoAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
Geert GOracle dbaCommented:
are you referring to a primary key of a table ?

http://www.w3schools.com/sql/sql_primarykey.asp
0
 
enrique_aeoAuthor Commented:
NO, this is in sql server
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '23987hxJ#KL95234nl0zBe';

in oracle?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
From the little I read about SQL Server Master Key encryption it looks like it is a way to encrypt data in the database.

In addition to the link above on Oracle TDE:
http://www.oracle.com/technetwork/database/options/advanced-security/index-099011.html

or possible Oravle Database Vault:
http://www.oracle.com/us/products/database/options/database-vault/overview/index.html
0
 
enrique_aeoAuthor Commented:
I can create multiple master key in oracle?
0
 
slightwv (䄆 Netminder) Commented:
I'm not a SQL Server person so I'm not 100% sure what all a 'master key' does so I'm not sure what you are trying to get Oracle to do.
0
 
enrique_aeoAuthor Commented:
in SQL Server I can create a single master key for bd, my question is whether oracle is equal?
0
 
slightwv (䄆 Netminder) Commented:
>>>single master key for bd

I do not understand what this means or does.

I guess you will have to wait for a SQL Server person that knows Oracle.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.