The server
script installation process automatically creates or configures a user for Oracle R Enterprise if one does not already exist.
Example 8-2 Creating an Oracle R Enterprise User
./server.sh . . Choosing ORE user ORE user to use [list]:
Press Enter to display a list of available users.
BI
HR
IX
OE
SCOTT
SH
ORE user to use [list]: ruser2
.
.
If you choose a user that exists, the script configures the user to support Oracle R Enterprise. If you specify a user that does not already exist, the script creates the user.
Example 8-3 Creating an Oracle R Enterprise User in SQL*Plus
You can create an Oracle R Enterprise user in SQL*Plus by following these steps:
Log in with system privileges:
SQLPLUS / AS SYSDBA
Execute a statement like the following to create the user:
CREATE USER ore_username IDENTIFIED BY password DEFAULT TABLESPACE default_tablepace_name TEMPORARY TABLESPACE temp_tablespace_name QUOTA UNLIMITED ON default_tablespace_name;
See Also:
Oracle Database SQL Language Reference for details about creating a user
Grant the required privileges:
GRANT CREATE SESSION,
CREATE TABLE,
CREATE VIEW,
CREATE PROCEDURE,
CREATE MINING MODEL
TO ore_username;
See Also:
Oracle Database SQL Language Reference for details about granting privileges to a user
The server
script installation process creates a database role called RQADMIN.
When the RQADMIN role is granted to an Oracle R Enterprise 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 Oracle R Enterprise user.
Note:
Any Oracle R Enterprise user can execute embedded R, but only Oracle R Enterprise users with the RQADMIN role can create and drop the R scripts.
As shown in User Configuration in Batch Mode, you can run the server
script with the --admin
option to grant the RQADMIN role to an Oracle R Enterprise user. The --admin
option is only available when you run the script in batch mode.
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 ore_username;
Caution:
Use caution when granting the RQADMIN role. Only users that require Oracle R Enterprise administrative privileges should have this role.
Related Topics