Oracle database configuration

Approved versions of Oracle

To see the approved versions of Oracle, access the Array of portability

Data Bank configuration

The administrator of the Oracle® database (DBA) must make some security changes to the Oracle® database, causing the user (schema) informed in the TOTVS Fluig Platform installation not to have permission to read/change in other schemas in the Oracle® database, if any.
Only the schema used by Fluig should have permission to read/change.

Create user and grant privileges

For the creation of a new user in Oracle database, we will use the instruction CREATE USER, according to the syntax below:

CREATE USER userid IDENTIFIED BY password [DEFAULT TABLESPACE tablespace] [TEMPORARY TABLESPACE tablespace_temporaria];

Where:

• userid: Name of user to be created;
• password: Password of user to be created;
• tablespace (optional): Default tablespace where objects in the data bank will be stored. If this option is omitted, Oracle assumes the default SYSTEM tablespace;
• temp_tablespace (optional): Default tablespace where temporary objects are stored, such as temporary tables. If this option is omitted, Oracle assumes a default TEMP tablespace;

After the user is created, it needs to be granted system privileges (DLL connections and instructions, for example) required for this user, according to the syntax below:

GRANT CONNECT,RESOURCE TO userid;

Where:

• userid: Name of previously created user;