1 Reply Latest reply: Aug 9, 2012 12:06 AM by Sherry Lamonica-Oracle RSS

    How can I set the  RQADMIN role?

      ORE> mod <- ore.doEval(
      + function() {
      + library(biglm)
      + dat <- ore.pull(ONTIME_S)
      + mod <- biglm(ARRDELAY ~ DISTANCE + DEPDELAY, dat)
      + mod
      + });
      错误于.ore.checkRole("RQADMIN") :
      RQADMIN role is required to perform this opeation
        • 1. Re: How can I set the  RQADMIN role?
          Sherry Lamonica-Oracle
          The ORE installation creates an administrative role RQADMIN and a user role RQROLE.

          The roles are used as follows:

          - Oracle R Enterprise users who are allowed to create R scripts that execute using
          the database embedded R engine must be granted the RQADMIN role.
          - Oracle R Enterprise users who are allowed to execute R code via SQL queries must
          be granted the RQROLE role.

          Create Users

          For an example of how to create an Oracle R Enterprise user, see.
          -demo_user.sh for Linux
          -demo_user.bat for Windows
          -demo_user.sh for Solaris
          -demo_user.sh for AIX

          For each Oracle R Enterprise user, these steps are required to fully enable the user on
          the database (as demonstrated in the demo_user.sh script).

          Start SQL*Plus as sysdba; then follow these steps:

          1. grant RQROLEto <Each ORE user>
          2. grant RQADMIN to <Each ORE user>
          2. grant execute on rqsys.rqGroupEvalImpl to <Each ORE user>
          3. Create all the synonyms listed in rquser.sql for each user.