Striim 3.9.4 / 3.9.5 documentation

Creating an Oracle user with XStream Out privileges

XStream Out is supported only for Oracle 11.2.0.4 with patches 6880880 and 21352635.

Log in as sysdba and enter the following commands to create a user with the privileges required by the Striim OracleReader adapter and a tablespace to store objects and messages related to XSteam administration. The path to the oradata directory in the DATAFILE property may vary depending on your installation. Replace ******** with a strong password.

CREATE TABLESPACE striim_xstream_tbs
 DATAFILE '/home/oracle/app/oracle/oradata/orcl/striim_xstream_tbs.dbf'
 SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE USER striim IDENTIFIED BY ********
 DEFAULT TABLESPACE striim_xstream_tbs
 QUOTA UNLIMITED ON striim_xstream_tbs;
exec dbms_xstream_auth.grant_admin_privilege('striim', 'CAPTURE', true)
GRANT CREATE SESSION TO striim;
GRANT SELECT ANY TABLE TO striim;

To verify that the user has been created correctly, enter the following command:

select * from dba_streams_administrator where USERNAME='STRIIM';

You should see the following:

USERNAME          LOC ACC
----------------- --- ---
STRIIM            YES YES

When you use XSteam Out in a Striim application, Striim will create the specified stream in Oracle automatically.