1. Installation and Administration Guide
  2. Administrative Tasks for Oracle Machine Learning for R
  3. Create a Database User for Oracle Machine Learning for R

7.6 Create a Database User for Oracle Machine Learning for R

In Database 23ai, the rquser.sql script shipped with Oracle Database 23ai resides in the $ORACLE_HOME/R/server directory. The script installs creates a new OML4R user, and the script rqgrant.sql in the same directory applies the required grants to the new user.

Example 7-2 Creating an OML4R User 

$ORACLE_HOME/R/server/rquser.sql

Example 7-3 Creating an OML4R User in SQL*Plus

You can create an OML4R user in SQL*Plus by following these steps: You can create an OML4R user with the following commands or by running the rquser.sql script. You can apply the required grants to an OML4R user with the following commands or by running the rqgrant.sql script.

Log in using system privilege and navigate to the PDB, if applicable:

  1. SQLPLUS / AS SYSDBA;

  2. alter session set container=<PDBNAME>;
  3. Provide the following arguments to the rquser.sql script:
    • Argument 1: User name (e.g., RQUSER)
    • Argument 2: User password
    • Argument 3: Default tablespace (e.g., USERS)
    • Argument 4: Temporary tablespace (e.g., TEMP)
    • Argument 5: Quota on default tablespace (e.g., unlimited)

argument 1 - user name (RQUSER)argument 2 - user passwordargument 3 - default tablespace (USERS)argument 4 - temporary tablespace (TEMP)argument 5 - quota on default tablespace (unlimited)

Parent topic: Administrative Tasks for Oracle Machine Learning for R