Storing the Reviewer workspace in an ArcSDE geodatabase

The following process outlines the steps for setting up a Reviewer workspace when working with ArcSDE geodatabases. Since access to the database tables is controlled by database permissions, it will be necessary to initialize the Reviewer workspace as the database owner and grant privileges to the appropriate ArcSDE users so they can access and work with Reviewer sessions.

Step 1: Create a Reviewer workspace in the ArcSDE geodatabase

The ArcSDE user that has owner privileges must start a new Reviewer session in the ArcSDE workspace where the Reviewer dataset will be stored.

When you start a Reviewer session, you are prompted to choose a workspace, which is a geodatabase that can contain the data you want to review or be a separate database that only contains the Reviewer dataset information, depending on your organization's workflow. By default, the user name is the Windows login name for the current user. You can also provide a custom name for the current Reviewer session.

The first time a database is used to store Reviewer information, a new dataset and tables are added to your database to accommodate the individual Reviewer sessions. All future sessions write to these same tables.

Steps:

1. Start ArcMap.
2. On the main menu, click Customize > Toolbars > Data Reviewer.
3. Click the Reviewer Session Manager button on the Data Reviewer toolbar.

   The Reviewer Session Manager dialog box appears.
4. Click Browse in the Reviewer Workspace area.

   The Reviewer Workspace dialog box appears.

5. Navigate to the geodatabase in which the Reviewer dataset is going to be stored.
6. Click Add.
7. Click New to start a new Reviewer session.

   The Reviewer Workspace Properties dialog box appears.
8. Choose an option for the spatial reference.
   • Use Default Spatial Reference (WGS-84)—Sets the Reviewer dataset's spatial reference to GCS_WGS_1984. This is the default spatial reference for ArcMap.
     Note:

     In most cases when using ESRI Aeronautical Solution, choosing the Use Default Spatial Reference (WGS-84) option is suggested.

   • Use Active Data Frame Spatial Reference—The Reviewer dataset's spatial reference matches that of the active data frame.
   • Browse To Spatial Reference—Sets the Reviewer dataset's spatial reference to one you choose.
     Note:

     If you choose Browse To Spatial Reference, the New Spatial Reference wizard appears so you can choose the spatial reference you want to use with the Reviewer dataset.

   Note:

   The spatial reference selected for the Reviewer dataset should match the spatial reference of the data you are validating. This allows the error geometry to be stored in the feature classes within the Reviewer dataset.

9. If necessary, choose the Use configuration keyword option in the Select Configuration Keyword area to choose a different configuration keyword for the database.
10. Click the Use configuration keyword drop-down arrow and choose a configuration keyword.

    The keywords available in the list are dependent on what the database administrator has specified in the DBTUNE table as configuration keywords.

11. Click OK.

    The ID and Name text boxes are automatically populated in the Session area.

12. If necessary, type a custom name for the current Reviewer session in the Name text box.

    By default, the name matches the ID.

13. Click the Reviewer Dataset Version drop-down arrow and choose the geodatabase version to be used.

    The geodatabase version you choose from the list is the one in which the Reviewer table records are going to be stored.

14. Click Start Session.

    The button name changes to End Session.

15. Click Close.

Step 2: Set the dataset and tables as versioned

The ArcSDE user that has owner privileges must set the following as versioned in ArcCatalog:

• RevDataset (feature dataset)
• RevBatchJobSummary table
• RevTableConfig table
• RevTableLocation table
• RevTableMain table
• RevCheckRunTable

Step 3: Grant permissions to the dataset and tables

The ArcSDE user that has owner privileges must grant SELECT, UPDATE, INSERT, and DELETE privileges to the following for all users that will be accessing Data Reviewer:

Note:

Permissions for the GDB_RevAdminLocation and GDB_RevTableSession tables must be granted directly in the relational database management system (RDBMS), not from ArcCatalog. Since these tables are prefixed with GDB_, they are considered geodatabase system tables and are not visible in ArcCatalog.

• GDB_RevAdminLocation table
• GDB_RevTableSession table
• RevBatchJobSummary table
• RevCheckRunTable
• RevDataset (feature dataset)
• RevTableConfig table
• RevTableGUIProperties table
• RevTableLocation table
• RevTableMain table

Learn more about adding and administering users in SQL Server

Step 4: Grant select permissions for the remaining Reviewer tables

The ArcSDE user that has owner privileges must grant SELECT privileges to the following tables for all ArcSDE users that will be accessing Data Reviewer:

• RevAdminCustomFields
• RevAdminDescriptions

Tips for granting permissions

• Only grant an ArcSDE user SELECT, UPDATE, INSERT, and DELETE privileges to the RevAdminCustomFields table if the ArcSDE user has privileges to modify the database schema.
• Only grant an ArcSDE user SELECT, UPDATE, INSERT, and DELETE privileges to the RevAdminDescriptions table if you want the ArcSDE user to be able to add customized error descriptions. Note that all other ArcSDE users accessing the Reviewer dataset will see the customized error descriptions.

Step 5: Configure cache tables for users

For enterprise geodatabases (Oracle and SQL Server) that create cache tables to store feature selections in ArcMap that are greater than 100, the ArcSDE user that has owner privileges must create the cache table for each ArcSDE user.

Steps:

1. Grant CREATE TABLE permissions for the user.
2. In ArcMap, select more than 100 features in the workspace that contains the Reviewer session information.

   This automatically creates the cache table.

3. Remove CREATE TABLE permissions as appropriate.

Once this process is complete, you have created a Reviewer workspace that can be used by the appropriate people in your organization who are working with ArcSDE data.