I am facing an issue with data mining create model.
DB version: 12.1.0.2.0 - 64bit
There are 2 users A and B.
User A has data mining privileges. So data mining related package with AUTHID as DEFINER is created in this user.
User B has privilege to access objects of user A.
When I invoke this package from user A (who is owner of this package) create model works fine.
But when i invoke this package from user B, it creates the model with size 0.
| Model Name | Mining Function | Alogirithm | Creation Date | Build duration | Size |
|---|
| MODEL_123 | CLASSIFICATION | NAIVE_BAYES | 05-JAN-18 | 4 | 0 |
Settings
PREP_AUTO => OFF
ODMS_TEXT_POLICY_NAME => ADP_DEFAULT_POLICY
ODMS_TEXT_MAX_FEATURES => 3000
NABS_SINGLETON_THRESHOLD => 0
Please help to fix this.