Set a Connection Pool's Permissions

A connection pool's permissions specify which application roles have read-write, read-only, and no access permissions to use the connection pool. For example, you can set up the users in the DV Content Author application role to have their own connection pool.

By default, all roles have read-only access to the connection pool. Add applications roles and assign permissions to limit who can use the connection pool.

Note:

You can use bulk update to set the permissions for multiple connection pools at the same time. See Set Semantic Model Object Permissions in Bulk.

Don't use connection pool permissions to determine data access security. For example, connection pool permissions don't protect cache entries.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon and locate and double-click a database.
  4. In the database's tab, click Connection Pools.
  5. In the connection pools list table, click a connection pool to select it and then click Detail view to open the properties pane.
  6. Scroll to Permissions.
  7. Click in the search field and type the name of a role, or enter * (an asterisk) to see the full list of roles. From the results list, click the role that you want to add to the permissions table.
  8. Specify the role's permission.
  9. Click Save.