Stat 6.1 - System Administration Guide

Table 16. Stat Central Agent Rights
Right	Description
Agent Jobs - Add	Enables the user to add new Stat Central Agent Jobs from within Job Maintenance
Agent Jobs - Edit	Enables the user to edit existing Stat Central Agent Jobs from within Job Maintenance
Agent Printers - Add	Enables the user to add new Stat Central Agent Printer definitions from within Stat Central Agent Printer Maintenance
Agent Printers - Edit	Enables the user to edit existing Stat Central Agent Printer definitions from within Stat Central Agent Printer Maintenance

Tool Rights

Some Tool rights are service domain-specific, while others are not. They control a user’s ability to access and work with certain utilities in Stat.

Table 17. Tool Rights
Right	Description
Agent Job Monitor	Gives the user access to the Agent Job Monitor in Stat Web
Agent Test Connect	Gives the user access to the Test Connect Page in Stat Web Client
Create Personal Rules	Enables the user to create Personal Rules
Data Replication - Inbound	Enables the user to replicate data into the current database from a different database
Data Replication - Outbound	Enables the user to replicate data from the current database to a different database
Enterprise Console -Workload Monitor	Enables the user to access the Enterprise Console
Launch INI File Editor	Enables the user to open the INI File Editor from Stat
PS Object Mover Instructions - Upd	Enables the user to update the PS Object Mover Instructions
Purge CSRs Without Doing Export	Enables the user to purge a CSR without creating an export file. CSRs purged this way can never be restored.
Run CSR Purge for Open CSRs	Enables the user to run the purge on Open CSRs. This should be rarely used.
Run CSR Purge Wizard	Enables the CSR Purge Wizard to be available on the Tools Menu.
Save System Report Criteria	Enables the user to add and edit system-level Report Criteria from within the Report Library
Schedule Reports	Enables the user to schedule reports to run automatically
Table Dump Utility - Run	Enables the user to run the Table Dump Utility

Wizard Rights

Some Wizard rights are service domain-specific, while others are not. They control a user’s ability to run certain wizards in Stat.

Table 18. Wizard Rights
Right	Description
Archive Set Sync Wizard - Migrate	Enables the user to migrate from the Archive Set Sync Wizard
Obj Archive Purge Wizard - Run	Enables the user to run the Archive Purge Wizard
Obj Archive Search Wizard - Run	Enables the user to run the Object Archive Search Wizard
Obj Mass Migration Wizard - Run	Enables the user to run the Mass Migration Wizard
Obj Migration History Wizard - Run	Enables the user to run the Migration History Wizard
Obj Recovery Wizard - Run	Enables the user to run the Recovery Wizard
Release Recovery - Run	Enables the user to run the Release Recovery Wizard
Undocumented Obj Wizard -Run	Enables the user to run the Undocumented Object Wizard
Undocumented Patch Wizard - Run	Enables the user to run the Undocumented Patch Wizard.

Appendix: Creating a Staging Database

Staging databases are used when migrating archive sets from your Stat database to a PeopleSoft database. A staging database is essentially a mini-PeopleSoft database with no application data and minimal tools data. Once created it should be maintained and tuned the same as other PeopleSoft databases in your environment.

Depending on the volume of objects moved or number of PeopleSoft tools versions you are supporting, you may decide to have multiple staging databases. This section describes how to create a staging database in Stat.

•

For PS version 8.x and higher – The staging database can either be a PeopleSoft demo (DEMO) or system (SYS) database. For detailed instructions on creating this database, please see your PeopleSoft Installation and Administration Guide. Financial databases in particular have a large number of tables used for sorting data. These can be dropped from the staging database.

Once you have created your AUD, Demo, or System database, execute the appropriate script

•

If running on Oracle, execute StageORA855.sql

•

If running on SQL Server, execute StageMSS855.sql

•

If running on DB2 execute StageDB2-OS390-855.sql (for mainframe), or StageDB2-UNIX-855.sql (for Aix/Unix)

These scripts complete the creation of a staging database. It is recommended that you create at least 2 staging databases. You may need to alter this script to match your platform.