 |
|
Oracle Tips by Burleson |
Oracle 10g Data Mining for Analytical
Multi-User Access Control
In Oracle 9i database, Data Mining provided
security to ensure the data mining metadata was not accessible by
mining schema users. Oracle Database 10g extends the capability of
metadata security.
In Oracle9i, you have two data mining schemas:
ODM and odm_mtr. The ODM schema was the user schema to host the
data mining datasets and metadata. The odm_mtr schema is the single
schema used to store input and output objects. Users can read and
write to the ODM repository in Oracle9i.
Oracle 10g has different schemas: the DMSYS
schema is the new repository schema for data mining metadata. Every
data-mining user has a distinct DM User schema. Operational data is
stored in the DM User schema and can be updated dynamically. This
new method of using Multi-User Access Control provides the following
benefits:
-
The DMSYS schema can restrict access to
specific data mining users.
-
The DM User schema combines input and
output datasets in a single schema, and thus eliminates network
access to an external physical dataset and improves performance.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
