OBIEE 11g: Data-Level / Object-Level Security - Query Limit

To set query limit and number of minutes a query can run per physical layer database connection, follow the below steps:

1. Login to Repository using OBIEE Admin Tool
2. Go to Manage > Identity
3. Go to Application Role tab, choose the role and double click on it to open.

4. Click on Permissions tab



5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.



Hope this helped!