Editing protection options

You use the Protection page of the Edit Shared Repository Storage window to update the protection options for the repository storage tables.

About this task

To update the protection options for the repository storage tables:

Procedure

  1. Open the Protection page of the Edit Shared repository Storage window.
  2. Depending on the current status of the Protection method check box, you can change the protection status of the repository storage table in one of the following ways:
    • Clear the Protection method check box to remove the protected status of the repository storage tables. This means that all users will have access to the repository storage tables and can make changes to any of those tables.
    • Select the Protection method check box to specify that you will protect the repository storage tables. The fields that you will use to specify the protection method become available.
  3. Select one of the following protection methods:
    • Select Stored procedures to specify that you will use stored procedures to protect the repository storage tables. You can select this option if the repository storage tables are located on one of the following databases:
      • Informix®
      • DB2® UDB LUW V10 and later
      • DB2 z/OS® V10 and later in NFM
      • DB2 iSeries (when accessed with IBM Toolbox JDBC driver)
      • Microsoft SQL Server
    • Select Static SQL packages to specify that you will use static SQL packages to protect the repository storage tables. You can select this option if the repository storage tables are located on a Db2 database that you will connect to using the IBM® DB2 Universal driver for JDBC or the Direct DRDA connectivity provided by the product (the latter option is available for Db2 for z/OS connectivity only).
  4. Type, or select from the drop-down list, the name that you want to use to identify the collection of stored procedures or static SQL packages in the Collection ID field.
  5. Optionally you can type the owner name in the Owner ID field, if you work with Db2® databases. The Owner ID provides the administrator privileges to the user who operates under the login without SYSADM authority.
  6. Click Create. The stored procedures are created or the static SQL packages are bound. A message is issued that informs you of the success of the either process. You can also use the Delete button to remove a collection of stored procedures or packages.
  7. Specify which users will have permission to run the stored procedures or static SQL packages for the repository storage tables on this database. To grant permission to all users, enter PUBLIC in the User IDs field and click Grant. To grant permission to specific users, type their user IDs in the field and click Grant. A message is issued that informs you that the selected user IDs have been granted permission to run the stored procedures or packages.

    Optionally, you can revoke permission to run the stored procedures or static SQL packages from any user that is listed in the User IDs list box. To revoke permission from one or more users, highlight one or more of the user IDs and click Revoke. A message is issued informing you that permission to run the stored procedures or static SQL packages has been revoked from the selected user IDs.

  8. If you have completed making changes to the repository storage properties, click OK. If you will be making additional changes, click the Objects or Connection tab, depending on the changes that you are making.