This content has been marked as final. Show 1 reply
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.
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.