The table in the repository schema stores information about users, groups, datasources, reports, privileges, preferences, and other defined variables and objects within the Netcool Reporter environment.
Typically these tables reside in their own tablespace or database, where access is restricted to the administrator of the Netcool Reporter application. The recommended configuration is to set up a storage area called REPORTER_REPOSITORY, with username repository_two and password repository_two. Keeping these tables separate from the Netcool Reporter event data tables ensures that no one, apart from the system administrator, accesses and queries these tables inappropriately. It also prevents extensive querying against the Netcool Reporter data hampering access to the repository tables.
The repository tables are set up by running the db.repository.sql script, where db is either oracle, sybase, or mssql. This script automatically creates the tables and populates them with the reports, forms, users, groups, and preferences that are already defined as part of Netcool Reporter.
The repository schema tables are:
• GRSQLCAT
• SMSEQUENCE
• DATASOURCE
• MACHINE
• RPAPP
• RPGROUP
• RPUSER
• VI_SUBSCHEMA
• RPFILETYPE
• DATAOBJ
• RPFILE
• CATEGORY
• RPCHILD
• VI_RECORD
• VI_RELATION
• VI_ELEMENT
• CANACCESSRPGROUP
• CATEGORYRPCHILD
• CATEGORYRPFILE
• CONTAINRPFILE
• LINKTOCATEGORY
• RPGROUPCATEGORY
• RPGROUPDATAOBJ
• RPGROUPDATASOURCE
• RPGROUPRPAPP
• RPGROUPRPCHILD
• RPGROUPRPFILE
• RPGROUPRPFILETYPE
• RPGROUPRPUSER
• RPUSERCATEGORY
• RPUSERDATAOBJ
• RPUSERDATASOURCE
• RPUSERRPAPP
• RPUSERRPCHILD
• RPUSERRPFILE
• VISATTR
• VI_FLDR_ITEM
• VI_FLDR_RLTN