The BI Interface database has two database users.
The first database user, FULL_USER is used to hold all the replicated tables and all the interface views and tables that are going to be created in the database schema of this user.
Not all of this data is needed when creating and designing reports, which is why a second database user, REGULAR_USER, is created. This second user has view access rights to all the tables and views except for: Full T_PSL interface, T_PSL, T_RAW_DATA, T_SLALOM_OUTPUTS, T_INTERMEDIATE_DATA.
The list of tables that need to be replicated is defined as a configuration parameter.
|
Copyright © 2013 CA.
All rights reserved.
|
|