Editing shared repository storage properties

You can edit the properties of shared repository storage.

About this task

To edit shared repository storage properties:

Procedure

  1. The Repositories view is usually open and docked to the left, next to the Repository Explorer view. If closed, you can open the Repositories view by selecting Repositories from the View menu.
  2. From the Repositories view, right-click the shared repository storage whose properties you want to modify. From the pop-up menu, select Edit. A multiple page Edit Repository Storage window opens displaying the properties that you can change.
  3. Select Connection to change the JDBC connection or user login information. The Connection page opens. You can make any of the JDBC connection or user login information changes from this page.
  4. Select Objects to update the repository storage database objects. The Objects page opens. You can update the repository storage database objects from this page.
  5. Select Protection to change the protection status of the repository storage tables. The Protection page opens. You can make any changes to the protection status of the repository storage tables and grant or revoke users access to the tables from this page.
    • Unprotected: Specifies that you will connect to the repository in unprotected mode. In this mode, dynamic query access to the repository storage tables, within which the repository resides, will be allowed. If the repository storage tables are restricted to the connecting user ID, the connection will fail. If the repository storage tables are unrestricted to the connecting user ID, the connection will be made and the dynamic query will process.
    • Auto: Specifies that the protection mode will be selected automatically depending on whether a collection of stored procedures or static SQL packages are available. If available, the repository storage tables within which the repository resides will be accessed using the specified stored procedures or static SQL packages. If the stored procedures or static SQL packages are unavailable, dynamic query access (unprotected mode) will be used.
    • Protected: Specifies that you will connect to the repository in protected mode using the specified stored procedures or static SQL packages to access the repository storage tables within which the repository resides. If the specified set of stored procedures or static SQL packages are not available, the connection will fail.
  6. Click OK. The Edit Repository Storage window closes. The changes that you have made are applied.