When you set the Enable Integrated Security Property for the first time in the knowledge base, the following happens:
External objects are used to access the GAM API and are consolidated in the GAM_Library folder.
GAM - Examples are consolidated in the GAM_Examples folder depending on the options selected during the Activation Process.
This data store is called "GAM" and is created following these criteria:
If the Reorg Data store is a SQLserver data store, the default values for "GAM" data store are as follows:
- Database Name is the same as the Database Name of the Reorganization data store.
- Database Schema: This property is set by default to "gam" value.
The GAM repository will be located by default in the same database as the default database; however, the schema will be another one named "gam".
If the Reorganization Data store is MySQL, the default value for "GAM" data store is as follows:
- Database Name: by default it is set to <Default data store database name>_gam.
The GAM repository will be under a different database by default.
In an Oracle database, GeneXus does not set any default value for the Database Name; this value must be set by the user.
Important:
The GAM reorganization process, in addition to the registration of GAM applications and the generation of permissions, is done inside GeneXus using ADO. NET. That's why the GAM data store has to be configured for ADO. NET connection (Access Technology = ADO. NET) even if the application is Java. When the application is generated in Java, both connections (Java and ADO. NET) have to be configured.
After pressing F5, a connection is established to the database specified in GAM data store (using the connection properties of this data store: database name, user ID, user password), checking for the existence of some tables and GAM version.
Given that these tables don't exist, the GAM database tables are created. So, the following happens:
- The GAM database and all its tables are created. Before the tables are created, the user is asked if he/she wants to create the GAM database and its tables.
The administrator user is created.
Also, Permissions are generated (if Integrated Security Level property = Authorization).
}