Allow or Disallow Direct Database Requests

You can specify if you want an application role to be able to run direct database requests.

What you specify in the Query Limits Execute Direct Database Requests field overrides what you selected in the Allow direct database requests by default field in the physical database's Advanced tab.

The options for the Execute Direct Database Requests field are:

• Allow - Grants the ability to run direct database requests for this database.

• Disallow - Denies the ability to run direct database requests for this database.

• Inherit - Inherits limits from the parent application role. If there is no limit to inherit, then direct database requests are allowed or disallowed based on the Allow direct database requests by default property for the database.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer .
4. In the Physical Layer pane, locate and double-click the database that you want to assign query limits to.
5. Click the Query Limits tab.
6. Locate the role name that you want to specify direct database requests for, go to the Execute Direct Database Requests field, click it, and select an option.
7. Click Save.