Page Comparison

...

1. Install Oracle Server: An Oracle Server has to be installed. The server computer has to be accessible for all client PCs through the local network/internet.
2. Create an Oracle user: It is highly recommended that this user is used only for the Performer Suite. All the tables are created in the user’s schema: “schema.tablename”. The tables are visible only for the given Oracle user. They have no interaction with any other user’s tables.
3. Provide rights for the Oracle user: The Oracle user must have full rights to manipulate its own database. He must be able to connect, create/modify tables, write / read data. Necessary roles are CONNECT and RESOURCE.
4. Install Oracle client on all client computers: Connecting to an Oracle database requires an Oracle client installed. The version of the client must be compatible with the version of the server.

...

To successfully use an Oracle database, the database user has to have these rights:Image Removed Granted Roles and System Privileges:
Scroll further down to see the direct SQL statement to save time.

1. CONNECT
2. DBA

3. RESOURCE

1. Alter any index
2. Alter any type
3. Alter session
4. Create any sequence
5. Create any table
6. Create session
7. Create table
8. Create tablespace
9. Create view
10. Drop any sequence
11. Drop any type
12. Select any table
13. Unlimited tablespace
14. Update any table

Image Added

Image Added

-- USER SQL
CREATE USER DocuPerformerPerformerSuite IDENTIFIED BY "docutool2020docutool2021" 

DEFAULT TABLESPACE "SYSTEM"
TEMPORARY TABLESPACE "TEMP";

-- QUOTAS

-- ROLES
GRANT DBA, CONNECT, RESOURCE TO PerformerSuite ;

-- SYSTEM PRIVILEGES
GRANT ALTER ANY INDEX TO DocuPerformerPerformerSuite ;
GRANT DROP ANY SEQUENCE TO DocuPerformerPerformerSuite ;
GRANT ALTER SESSION TO DocuPerformerPerformerSuite ;
GRANT CREATE ANY SEQUENCE TO DocuPerformerPerformerSuite ;
GRANT CREATE VIEW TO DocuPerformerPerformerSuite ;
GRANT CREATE SESSION TO DocuPerformerPerformerSuite ;
GRANT SELECT ANY TABLE TO DocuPerformerPerformerSuite ;
GRANT CREATE TABLE TO DocuPerformerPerformerSuite ;
GRANT CREATE TABLESPACE TO DocuPerformerPerformerSuite ;
GRANT DROP ANY TYPE TO DocuPerformerPerformerSuite ;
GRANT UPDATE ANY TABLE TO DocuPerformerPerformerSuite ;
GRANT ALTER ANY TYPE TO DocuPerformerPerformerSuite ;
GRANT UNLIMITED TABLESPACE TO DocuPerformerPerformerSuite ;
GRANT CREATE ANY TABLE TO DocuPerformerPerformerSuite ;

How to connect to Oracle from Performer Suite?

You will be asked to select a database during the configuration of the Performer Suite. To establish an Oracle connection the server name has to be provided, with the created user credentials: name and password. The server name must be provided in the following format: servername:port/instance. Server name sample: 192.168.1.84:1527/orcl.test.net.

...