The Reporting Build Environment provides a quick and easy way to grant the required privileges that the Data Warehouse needs. However, it should only be used in a Development Environment, when the source data is from a database that resides on a different database instance to the staging database, and not in an environment where there are stricter security priorities, like a Production Environment.
The BIApplication.properties file contains these variables which, when set to True, automatically grant the required privileges:
The grant.all command, which gets called by database.all, grants the permissions from tables/views in Source, Staging, Central to the Staging, Central, Datamart databases respectively:
each and everyone of which need to be specified in the relevant grant file for all components:
which are located in the Reporting\Components\<Specific Component>\Run\Oracle folder for each individual component
In order for the grant.all command to execute successfully please ensure that the Source, Staging and Central users have the correct grant authority.
In a Development Environment, if the source data is coming from an external database different to the staging database, please ensure that:
If the source data is from the same database as that of the staging database, ensure both are set to true.
In a Production Environment, please ensure that these two autogrant variables are set to false, which is the default. Relevant production environment to meet personal security requirements will then need to be set up.