Adding Grid Format, Watchlists, and Query Security through the UDO View Security Form

1. Access P00950.

2. Select the Form menu, User Defined Object View.

3. On Work With User Defined Object View Security, click the Add button.

4. Specify the appropriate Object Type. For example, enter:

   • FORMAT

   • WATCHLIST

   • QUERY

5. In an empty row in the grid, complete the following fields:

   • User/Role. Enter a user or role for which you want to enable access to the Data Browser.

   • Application Name. Enter DATABROWSE.

   • Form Name. Click Search to locate a Watchlist, Query, or Format object that users or roles can access through the Data Browser. To grant access to all Watchlist, Query, or Format objects, enter *ALL. You can also enter a Product Code or Reporting Code to restrict the search to objects associated with a specific product or reporting code.

6. Click the OK button.

7. Set up additional records as necessary.

Note:

The Legacy Security (F00950) table controls access to the Data Browser. Users who are denied access in the F00950 table cannot access the Data Browser application.

Enhanced Data Browser security provides more control by allowing administrators to restrict access to specific tables, views, and data sources. For example, in a development environment, users can be granted access to all tables and views while being restricted from Production data sources. In a production environment, users can access the Data Browser with visibility limited to authorized tables and views.

Important:

To ensure that Data Browser security functions correctly, you must complete these tasks:

Adding Data Browser Security, Adding Data Browser Security through the UDO View Security Form, and Adding Grid Format, Watchlists, and Query Security through the UDO View Security Form.