7.6 Create a Database User for Oracle Machine Learning for R

In Database 26ai, the rquser.sql script shipped with Oracle AI Database 26ai 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 Oracle Machine Learning for R User 

$ORACLE_HOME/R/server/rquser.sql

Example 7-3 Creating an Oracle Machine Learning for R User in SQL*Plus

You can create an Oracle Machine Learning for R user in SQL*Plus by following these steps: You can create an Oracle Machine Learning for R user with the following commands or by running the rquser.sql script. You can apply the required grants to an Oracle Machine Learning for R 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