Solved

About data masking and licenses in Oracle

Posted on 2011-09-06
6
982 Views
Last Modified: 2012-06-27
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
Comment
Question by:miyahira
6 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36492441
You should ask Oracle this directly to ensure you are legal with what you are proposing.
0
 
LVL 1

Author Comment

by:miyahira
ID: 36492486
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
 
LVL 20

Expert Comment

by:gatorvip
ID: 36495490
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Accepted Solution

by:
miyahira earned 0 total points
ID: 36498440
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
 
LVL 1

Author Closing Comment

by:miyahira
ID: 36521422
Found by myself.
0
 
LVL 11

Expert Comment

by:Akenathon
ID: 36500727
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 51
Oracle SQL queries -- Challenging question 13 64
Cannot open form error 6 49
JDeveloper 12c for 32 bit 4 35
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now