Configuring Oracle Data Miner Users

You must grant the required privileges to the user to start using Oracle Data Miner. This topic shows how to grant privilege to an existing user, and how to create a new user and grant the privileges to the user.

To grant required privileges to an existing user:

1. Run the following sql script from the SQL Developer home directory sqldeveloper/dataminer/scripts:

   @@usergrants.sql {username}

   In the example, the required privileges are granted to an existing Autonomous Database user OMLUSER02.

   Figure 4-4 Script to grant privileges

   
2. To create a new user and grant the required privileges to the user, run the following script from sqldeveloper/dataminer/scripts:

   @@createuser.sql {username} {password}

   Figure 4-5 Create user and grant privilege

   

This completes the task of granting privileges to an existing user, and creating a new user and granting the required privileges to the newly created user.