• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1132
  • Last Modified:

About data masking and licenses in Oracle

Hello,

We are trying to implement data masking for testing data.

I know that this feature is available with Oracle Enterprise. However for us it's very expensive.

In order to lower license costs, could be possible to have an Oracle Enterprise only for one named user, or have an Oracle Personal or Express Edition for data masking.

Maybe it's possible to have one Oracle server with data masking feature, mask data, and export that data to other databases.
0
miyahira
Asked:
miyahira
1 Solution
 
slightwv (䄆 Netminder) Commented:
You should ask Oracle this directly to ensure you are legal with what you are proposing.
0
 
miyahiraAuthor Commented:
Yes, of course I asked Oracle, but their salesmen (at least in my country) are not so fast or don't like to answer this kind of questions.

Just asking if someone had some similar license experience, so I can ask Oracle with more information.
0
 
gatorvipCommented:
Take a look at the licensing options here:
http://www.oracle.com/us/corporate/pricing/specialty-topics/index.html

In particular, you want to look at the policies document ( http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf )

In short, for a testing environment, you need a license. For a development environment, you do not need an additional license as long as the development is restricted to 1 user per 1 computer per install.

However, this is just my interpretation of their documentation and you shouldn't necessarily rely on it. The Oracle reps are best suited to answer licensing questions.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
miyahiraAuthor Commented:
It's not possible.

http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/options.htm#DBLIC2114

"Oracle Data Masking Pack must be licensed for those databases servers where the masked data originates from as well as those database servers containing the masked data."
0
 
miyahiraAuthor Commented:
Found by myself.
0
 
AkenathonCommented:
You can do what you say... there's nothing wrong in processing your data on an EE at the minimum license, and then export the data to a SE at your production licenses. Nobody will say anything against your usage of the exported data. Some pitfalls:

- Some licenses have minimums, e.g. you can buy by named user, but they won't license anything below 25 users. That's something only your Oracle representative can confirm... look into Personal Oracle, I think it's the only one that can be licensed for just one user (actually it's MEANT to be licensed for just one user!)
- If your structures have anything only supported by EE, they cannot be directly transported onto a SE. For instance, a create table with partitions will fail if you run it on a DB without the partitioning option. However, the data can still be merged on a SE non-partitioned table. Same for advanced compression options, etc.
- What you CANNOT do is make use of their free license for prototyping and/or personal study to use an EE for this. You would be using the EE as part of your testing environment, so it's clearly NOT allowed

Remember you can always run some custom scripts to scrub sensitive data after cloning the production DB into the testing environment. Actually that's what everybody did before masking was invented :-)
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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