Creating a Data Mining User

A Data Mining user is a database user account that has privileges for performing data mining activities. Example 8-6 shows how to create a database user. Example 8-7 shows how to assign data mining privileges to the user.

Note:

To create a user for the Data Mining sample programs, you must run two configuration scripts as described in The Data Mining Sample Programs.

See Also:

Oracle Database SQL Language Reference for the complete syntax of the CREATE USER statement

Example 8-6 Creating a Database User in SQL*Plus

    Enter user-name: sys as sysdba
    Enter password: password

To create a user named dmuser, type these commands. Specify a password of your choosing.
```
CREATE USER dmuser IDENTIFIED BY password
       DEFAULT TABLESPACE USERS
       TEMPORARY TABLESPACE TEMP
       QUOTA UNLIMITED ON USERS;
Commit;
```
The USERS and TEMP tablespace are included in the pre-configured database that Oracle ships with the database media. USERS is used mostly by demo users; it would be appropriate for running the sample programs described in The Data Mining Sample Programs. TEMP is the temporary tablespace that is shared by most database users.

Note:

Tablespaces for Data Mining users should be assigned according to standard DBA practices, depending on system load and system resources.

To login as dmuser, type the following.

CONNECT dmuser
Enter password: password