[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 694
  • Last Modified:

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?
0
enrique_aeo
Asked:
enrique_aeo
2 Solutions
 
Geert GruwezOracle 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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now