• Apia ALL.ALL.ALL

When installing Apia or ApiaBI, ApiaInstaller it will request 2 users of access to database. These users are used for different actions, at different moments. Database users that Apia uses are:

• Installation user.
• Execution user.

Installation user
Installation user of Apia or ApiaBI in database is used by ApiaInstaller to install and/or update Apia or ApiaBI. This user must have the following permits:

• Creation/Alteration/Removal of grids. 
• Creation/Alteration/Removal of views. 
• Creation/Alteration/Removal of sequences (only for ORACLE databases).
• Creation/Alteration/Removal of stored procedures (only for Ms. SQL Server databases)
• Creation/Alteration/Removal of functions (only for PostgreSQL database).
• "Select" on all the views and grids. 
• "Insert/Update/Delete" on all the grids.
• Execution on all the sequences/stored procedures/functions (depending on database).

Execution user
Execution user of Apia or ApiaBI in database is used to obtain/add/update/delete data from Apia's database. This user may have the following pemits:

• "Select" on all the tables and views.
• "Insert/Update/Delete" on all the grids.
• Execution on all the sequences/stored procedures/functions (depending on database).

If Apia is updated, and depending on how user's permit of execution and installation are set, it may occur that permits of execution user have to be altered, to obtain access to new elements or to elements that have been updated by installation user.

For ApiaBI, it is necessary that the execution user also has the following permits on ApiaBI database:

• Creation/Alteration/Removal of grids. 

It is advisable that in Apia's database and BI' database, there are no other grids that are not exclusive of Apia. Also, it is advisable that installation user is the owner of the scheme were database is installed.

[ ATI00081 ]		ApiaInstaller's versions which must be used for each Apia Release
[ AHT00102 ]		Install Apia
[ AHT00103 ]		Update APIA
[ AHT00168 ]		Apia installation in JBoss

[ ANF01557 ]		Libraries update
[ AHF00078 ]		Update of 2.2.162.17 to 2.2.162.18 or Update of 2.2.163.x to 2.2.163.6
[ ADF01553 ]		Apia 2.4 Installation handbook
[ AHF00040 ]		Update of Labels in Apia 2.2.162.8
[ AHF00128 ]		Update of labels in Apia 2.2.162.32
[ AHF00115 ]		Update of labels in Apia 2.2.162.9
[ AHF00074 ]		Update of labels in Apia 2.2.162.18
[ AHF00085 ]		Update of labels in Apia 2.2.162.21
[ AHF00034 ]		Update of labels in Apia 2.2.162.6
[ AHF00121 ]		Update to Lucence 2.0