Skip to main content

Create a Data Permission


This topic has moved from Safe Haven to the Data Hub documentation. For up-to-date information, update your bookmarks.

You can create data permissions for tables, views, and user-defined functions that are owned by your organization as indicated in the Owned By column on the All Assets page. You can also create a data permission from the Assets section on the SQL Editor page.

Before creating a permission:

  • Go to the Permissions page to verify that permission to use the table, view, or function has not already been granted to the partner. An error message is displayed if you try to grant a second permission for the same asset and partner:

  • If you want to apply a query threshold (minimum aggregated results), verify that your selected asset has a valid ID column, because query results are aggregated at the ID column level.

  • You cannot grant permission to a user-defined function owned by another organization. Click the function's row to display its side panel, which includes the name of the organization that owns it. If the function's More Options more-options-icon.png menu includes the Create Permission option, your organization owns it.

Procedure. To create a data permission:
  1. In the left-hand pane, click ManageAll Assets. The All Assets page is displayed.

  2. Click the row for the table, view, or function for which you want to grant permission. Its More Options more-options-icon.png icon is displayed:

  3. Click the More Options icon and select Create Permission.


    The Create Permissions dialog displays its Details page.

  4. Enter a name for the permission, select the partner to whom you want to grant permission, specify start and end dates, and then click Next.


    For tables and views, the Collaboration Rules page displays the Query Thresholds tab.


    Collaboration rules do not apply to user-defined functions, so the Summary page is displayed instead (See step 7).

  5. To set query limits, select the Set minimum for aggregated query results check box and select the granularity of the query results. If the results of a query do not meet the specified minimum, those rows will not be displayed.


    You may specify the minimum number of aggregated records and the column it will be aggregated against.

    • 2 records: This option restricts row-level access and provides the most granular results.

    • 25 records: Sets a minimum level of aggregation at 25 results.

    • 75 records: Sets a minimum level of aggregation at 75 results.

    • Other: Enter a custom value up to a maximum of 1000 results.

    • Household RampID: Aggregate based on the household ID column (typically called "hhid").

    • RampID: Aggregate based on the RampID column.

    • Other: Aggregate based on one or more of the columns found in the asset.

  6. Click Next. The Data Combinations tab displays the following options:

    • My Partner's Data Hub data: Select this option to allow your partner to combine their data with your data asset.

    • 3rd-party data from Data Providers: Allow your partner to combine their third-party data with your data asset.

    • Data shared with my partner from other Data Hub accounts: Allow your partner to combine your data asset with data that Data Hub partners shared with them and select one of the following options:

      • Data shared with my partner from ANY Data Hub account: Allow your partner to combine your data asset with data from any other Data Hub partners that were shared with them.

      • Data shared with my partner from specific Data Hub accounts: Select this option if you want to specify certain Data Hub partners' data with which your partner can combine your data asset.

  7. Click Next and review the Summary page.

  8. Click Confirm Permission or click Previous if you decide to adjust the permission.

    The permission is available on the Permissions page, where you can view its status, details, modification history, and expiration. You can edit and revoke the permission at any time on the Permissions page.