What does splex_role_both do?
splex_role_both is created by the ora_setup program.
It is the DBA role that the below documentation refers to.
From the installation guide chapter " UNIX Installation and Setup". Step 21:
SharePlex requires a master Oracle account (schema and user) that will be used by all SharePlex processes to interface with Oracle. The account is created during the ora_setup portion of the installation. To perform replication, SharePlex must have a DBA role and unlimited privileges, tablespace privileges, and read privileges to the redo logs. This privilege remains in effect unless it is explicitly changed. The default user is [SPLEX/SPLEX].
Important: The SharePlex user is created with the default Oracle profile under the assumption that the profile has the unlimited resource privileges originally assigned
by Oracle. View the profiles in your database to verify that the default is unlimited. If the default has been changed, assign SharePlex a DBA profile with unlimited privileges for all definitions.
The following grants are required for the SharePlex user, where splex in the syntax is the name of your SharePlex user.
To replicate DDL supported for Oracle 9i (e.g., when setting SP_OCT_REPLICATE_DDL_ALL=1), the SharePlex Oracle user requires the following grants:
grant select any table to splex with admin option;
grant create any view to splex with admin option;
For Oracle 9i or 10g, the SharePlex Oracle user requires the following grant to access the data dictionary if O7_DICTIONARY_ACCESSIBILITY is set to
FALSE.*
grant select any dictionary to splex;
For Oracle 8i, the SharePlex Oracle user requires the following grant to access the data dictionary if O7_DICTIONARY_ACCESSIBILITY is set to FALSE.*
grant select catalog role to splex;
*(SharePlex requires access to the dictionary tables outside of the standard DBA roles.)
