Step 2a: Creating the Oracle user for EBICS Server

Only read this section if you are using an Oracle database.

When using an Oracle database with EBICS Server, you must assign certain privileges to the database user.

Log on as a system user: system/******
Create the required tablespaces:
- EBICS_DATA_WORK - to hold data, and
- EBICS_INDEX_WORK - to hold indexes
These names are the default names used during the installation process. You can change them to any Oracle-compliant name, as long as you specify the names in the Installer screen during installation.
Create a user with the characteristics (example values):
- Name = bankrechner
- Password = bankrechner
- Default tablespace = EBICS_DATA_WORK
- Temporary tablespace = TEMP
Grant rights using the following commands:
- grant CONNECT to bankrechner;
- grant ALTER SESSION to bankrechner;
- grant CREATE SESSION to bankrechner;
- grant CREATE SYNONYM to bankrechner;
- grant CREATE TABLE to bankrechner;
- grant CREATE VIEW to bankrechner;
- grant CREATE SEQUENCE to bankrechner;
- grant unlimited tablespace to bankrechner;
For XA access, check that the user is able to access the DBA_PENDING_TRANSACTIONS table:
Connect to the database with this user, and check the privileges using one of the following methods:
- select * from user_tab_privs where table_name='DBA_PENDING_TRANSACTIONS'
- select * from DBA_PENDING_TRANSACTIONS;
- select grantee, privilege what_granted
- from dba_tab_privs
- where table_name = 'DBA_PENDING_TRANSACTIONS'
- /
If the privilege 'DBA_PENDING_TRANSACTIONS' is not granted, run the following command using a sysdba user:
- grant select ON DBA_PENDING_TRANSACTIONS TO bankrechner;
- grant select on sys.dba_pending_transactions to bankrechner;
- grant select on sys.pending_trans$ to bankrechner;
- grant select on sys.dba_2pc_pending to bankrechner;
- grant execute on sys.dbms_system to bankrechner;