8.7 Creating a Database User for Oracle R Enterprise

The server script installation process automatically creates or configures a user for Oracle R Enterprise if one does not already exist.

Example 8-2 Creating an Oracle R Enterprise User

./server.sh
.
.

Choosing ORE user
  ORE user to use [list]:

Press Enter to display a list of available users.

BI
HR
IX
OE
SCOTT
SH
  ORE user to use [list]: ruser2
.
.

If you choose a user that exists, the script configures the user to support Oracle R Enterprise. If you specify a user that does not already exist, the script creates the user.

Example 8-3 Creating an Oracle R Enterprise User in SQL*Plus

You can create an Oracle R Enterprise user in SQL*Plus by following these steps:

  1. Log in with system privileges:

    SQLPLUS / AS SYSDBA

  2. Execute a statement like the following to create the user:

    CREATE USER ore_username IDENTIFIED BY password
DEFAULT TABLESPACE default_tablepace_name
TEMPORARY TABLESPACE temp_tablespace_name 
QUOTA UNLIMITED ON default_tablespace_name;

    See Also:

    Oracle Database SQL Language Reference for details about creating a user

  3. Grant the required privileges:

    GRANT CREATE SESSION,
      CREATE TABLE,
      CREATE VIEW,
      CREATE PROCEDURE,
      CREATE MINING MODEL
TO ore_username;

    See Also:

    Oracle Database SQL Language Reference for details about granting privileges to a user

8.7.1 About the RQADMIN Role

The server script installation process creates a database role called RQADMIN.

When the RQADMIN role is granted to an Oracle R Enterprise user, the user can create and drop R scripts for embedded R execution. By default, the server script does not grant the RQADMIN role to the Oracle R Enterprise user.

Note:

Any Oracle R Enterprise user can execute embedded R, but only Oracle R Enterprise users with the RQADMIN role can create and drop the R scripts.

As shown in User Configuration in Batch Mode, you can run the server script with the --admin option to grant the RQADMIN role to an Oracle R Enterprise user. The --admin option is only available when you run the script in batch mode.

If you choose to grant the RQADMIN role in SQL*Plus, then log in with system privileges and execute a statement like the following:

SQLPLUS / AS SYSDBA
GRANT RQADMIN TO ore_username;

Caution:

Use caution when granting the RQADMIN role. Only users that require Oracle R Enterprise administrative privileges should have this role.

Related Topics