7.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 OML4R 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 OML4R user.

Note:

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

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 oml_username;

Caution:

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